Suppose you have a table T: ----------------------
A B ---------------------- 1 '111' 2 '222' ---------------------- How do you select A and B of the record with A maximum? The desirable result therefore is (2, '222') The two variants I could grow with are: 1) SELECT A, B FROM T ORDER BY A DESC LIMIT 1 2) SELECT A, B FROM T WHERE A IN (SELECT MAX(A) FROM T) What do yo think of the queries above? And give me the better implementation if possible. __________________________________________________________________ Dmitry Vitalievitch ICQ#: 11000008 Current ICQ status: + More ways to contact me __________________________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
