Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: a SQL quiz
You can try this query :
SELECT a.item,a.month,a.price
FROM my_table a
WHERE a.month = (SELECT MAX(b.month)
FROM my_table b WHERE a.item = b.item);
abray_at_club-internet.fr
BM Lam <1116-530_at_online.de> a écrit dans le message <373F4079.27DE1FFE_at_online.de>... Received on Sun May 16 1999 - 20:30:29 CDT