.Net Tips and Solutions
Friday, June 7, 2013
HOW TO DELETE ROWS FROM A TABLE WITHOUT USING WHERE CONDITION
If we want to delete top 1 row (or) top 2 (or) top 3 (or) top 5 ... etc
We use the query below
Syntax::
Delete top (no. of rows) from <table name>
example::
delete top (2) from tbEmployees
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment