SELECT date1, process, wip, worm FROM table WHERE field=value ORDER BY
otherField DESC LIMIT N
Seena Blace wrote:
Hi,
how to get top N records from table ?
columns of table
id
date1
process
wip
worm
I need output
date1 process wip worm
5/5/05
5/6/05
5/7/05
thanks
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
