Page 1 of 1

how to select only 1 data out of few?

Posted: Mon Jan 05, 2009 4:58 am
by mit
bank remarking number 1 2009-01-05 18:16:29
bank remarking number 2 2009-01-05 18:16:31
bank remarking number 3 2009-01-05 18:16:32
bank remarking number 4 2009-01-05 18:16:33

i need to select only the last bank which is having remarking number4 and is the latest data that inserted into data base, i dont want to use time for this matter is there any other way?.
thx

Re: how to select only 1 data out of few?

Posted: Mon Jan 05, 2009 5:00 am
by mit
SELECT `remark` FROM `remarks` WHERE `project_name` = 'bank' this is showing all, whereas i need the last remark

Re: how to select only 1 data out of few?

Posted: Mon Jan 05, 2009 5:10 am
by VladSun
+
[sql]ORDER BY     remarking_number DESCLIMIT    1[/sql]

Re: how to select only 1 data out of few?

Posted: Sat Jan 10, 2009 10:42 am
by jason.carter
Try a sub query if you want

SELECT remarks FROM remarks WHERE remark_id = (SELECT max(remark_id) FROM remarks)

If you have a remark_id then it is fairly easy to pull the latest row.