I have two queries I am trying to combine into one. A simplified version of what I am doing:
SELECT * FROM table WHERE `id` = '1' ORDER BY `name`
SELECT * FROM table WHERE `id` = '2' ORDER BY `age`
I have looked into unions but the examples I find online are less than helpful.
You might be looking for something like this:
SELECT * FROM YourTable
WHERE id in('1','2')
ORDER BY id,CASE WHEN id=1 THEN age END,CASE WHEN id=2 THEN name END
As the id is part of the resultset, there is no need for UNION or other complicated tricks.
I'm quite sure, that age and name are not the same type. One single CASE WHEN might get into troubles here.
In my suggestion the ORDER BY uses three columns. This will translate to
ORDER BY 1,age,NULL
or to
ORDER BY 2,NULL,name
ORDER BY id,CASE WHEN id=1 THEN age END ASC,CASE WHEN id=2 THEN name END DESC. Think of the CASE WHEN ... END as one single value...The below code will simply put together the results of each. There isn't much more to it.
SELECT * FROM table WHERE `id` = '1' ORDER BY `name`
union
SELECT * FROM table WHERE `id` = '2' ORDER BY `age`
ORDER BY must be applied to the outer-most select) there is absolutely no use for union at all... This is procedural thinking. The server will not work things down in the order you'd expect this. You might use a table with an IDENTITY column and insert both statements one after the other. In this case your table would combine both resultsets in the way you seem to expect it here...Apply the Union operator between both queries. Please take care about selecting same column name and sequence into both the queries like below:
SELECT id,columnname1,columnname2 FROM table WHERE id = '1'
union
SELECT id,columnname1,columnname2 FROM table WHERE id = '2'
select ... from table where id in(1,2) just with a lot of overhead...select * from (select id from table1 where id=1 order by id) UNION select * From (select id from table2 where id=2 order by name ); this is working fine with oracle.
UNION at all (see existing answers) and 2) Only the outer-most ORDER BY is relevant. This call might return in differing order from call to call...
unionorunion all. Also which DBMS are you using?where id in (1,2).