Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers
Home / Oracle / Database / What does TOP Operator Do?

What does TOP Operator Do?
Print
Email to friend
Add comment
Views: 65
Votes: 0
Comments: 0
The TOP operator is used to specify the number of rows to be returned by a query. The TOP operator has new addition in SQL SERVER 2008 that it accepts variables as well as literal values and can be used with INSERT, UPDATE, and DELETES statements.
Others in this Category
document What is Isolation Levels?
document What is an execution plan? When would you use it? How would you view the execution plan?
document What is Filestream?
document What is sub-query? Explain properties of sub-query?
document What is use of DBCC Commands?
document What is Filtered Index?
document What is use of EXCEPT Clause?
document List few advantages of Stored Procedure.
document What is a table called, if it has neither Cluster nor Non-cluster Index? What is it used for?
document How to find tables without Indexes?
» More articles


RSS
Powered by KBPublisher (Knowledge base software)