Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

How to select single row

Hi,
I am working in java and accessing Ms access. I need a query that how to read single row from table. I used LIMIT caluse but its giving error. Pls help :confused:
[177 byte] By [kalyan_2001148] at [2007-11-11 7:42:58]
# 1 Re: How to select single row
Try:

SELECT TOP 1 * FROM TableName ORDER BY ColumnName
Phil Weber at 2007-11-11 23:47:44 >
# 2 Re: How to select single row
Thanks for the information. :)
kalyan_2001148 at 2007-11-11 23:48:49 >