Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help with a select statement
I need to do the following, but dont know how:
select (select max(status) from tickets where location = 'NY'),
(select max(status) from tickets where location = 'NJ') FROM tickets;
If anyone could shine some light on how to do this, it would be appreciated. Received on Sun Mar 30 2003 - 23:59:06 CST