Limiting a Query to a number of records 2

[elquiff]

Please help and the answer might be simple.

I have a table that I wish to run a query on to pull back only the firt 10 rows. Does anybody know the sql command that will do this. In mysql its limit.

Thanks

 

[GHolden]

You need to use TOP.

eg.

SELECT TOP 10 <field>, <field> FROM <table>....etc

There are two ways to write error-free programs; only the third one works.

 

[elquiff]

cheers it works new it would be something simple.