Tuesday, July 5, 2011

Query for selecting first 3 rows from the table

set rowcount 3
delete fromexcel
set rowcount 0
select * from excel

The above query retrieve and show first 3 rows of records from the table,The set rowcount=0 stop the process suddenly and help to show only 3 rows.






No comments: