Make only one query to get data from the same table

Question

What the best way to make only one call to the DB in this case :

query="""SELECT measure FROM data 
         WHERE id =%s AND pId = %s AND data_type ='total' 
         ORDER BY createdAt DESC LIMIT 1;"""
lines = self.cursor.execute(query,(id,pId))

query="""SELECT measure FROM data 
         WHERE id =%s AND pId = %s AND data_type ='tot_m' 
         ORDER BY createdAt DESC LIMIT 1;"""
lines = self.cursor.execute(query,(id,pId))

Works fine but are made 2 queries to the table. What best way to do the in one query ? Thx in advance and sorry for my english...

@George see my new answer below if that works for you please upvote — dataviews, Aug 01 '18 at 16:04
Possible duplicate of [PHP/MySQL - Select One of Each Type In Table](https://stackoverflow.com/questions/29776933/php-mysql-select-one-of-each-type-in-table) — Sunny Patel, Aug 01 '18 at 16:07

score 0 · Answer 1 · answered Aug 01 '18 at 15:58

Try this:

query="""SELECT measure FROM data 
         WHERE id =%s AND pId = %s AND data_type ='total' 
         ORDER BY createdAt DESC LIMIT 1;
         UNION
         SELECT measure FROM data 
         WHERE id =%s AND pId = %s AND data_type ='tot_m' 
         ORDER BY createdAt DESC LIMIT 1;"""
lines = self.cursor.execute(query,(id,pId))

Make only one query to get data from the same table

1 Answers1