Limit In SQL Statement

[tunesguy]

Is it possible to use LIMIT in your asp.net SQL statement (SELECT * FROM news LIMIT 2) and if you cannot then how could i just select 2 records and not the whole set of data?Of course it depends on which 2 records that you want to select. If you just want the first 2 records, you could do this:<BR><BR>SELECT TOP 2 * FROM tblName