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.
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:
Post a Comment