i have a student details in a database.
Now i want to fetch only top 5 records from studentTable..

I am try in sql statement(top 5), it become a error...

i want to know what is error?
or there some other way to fetch first 5 records from table..

what database are you using?

TOP is a T-SQL variation so is MS specific

i am using MSACCESS9.0

in that case

SELECT TOP 5 fieldlist FROM table

should work ok. What query are you using and what is the error?

Thanks chrishirst!

i use top(fieldlist) instead of top 5 fieldslist.