how to use rowcount to delete rows?

[sandeepk84]

hi all...

can anyone tell me how we can use rowcount to delete some rows from a table..
means, i have some rows in d table. and i have to delete some rows (from beginning) based on some condition.i the form i can't get any existing column values to specify a condition...so d only way is to specify rowcount...like , delete first 3 rows from table...how can i do this?
please help...

thanx and regards...
sand....

[iburyak]

Follow this example from help:


[PHP]
DELETE authors
FROM (SELECT TOP 10 * FROM authors) AS t1
WHERE authors.au_id = t1.au_id[/PHP]