How to select one record through SQL?

[ganraj]

Hello!

I want to select any one record from access database without using where clause.How do I do it? I am using VB 5.0 with access MDB.

Can anyone help?



------------------
ganraj.

[JHausmann]

Why?

If you don't use a where clause, your only other choice is a table scan (sequential read of all table data).