adspace


what is top in tsql? : Transact sql

Answer Posted / Rahul Pandey

In T-SQL, the TOP keyword is used to retrieve only a specified number of rows from the result set. The syntax is as follows: SELECT TOP (n) columns FROM table_name; where 'n' is the number of rows to return.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the best sql course?

1050


define sql insert statement ? : Sql dba

1098


What is your daily office routine?

2346


what is collation? : Sql dba

1229


what is bcp? When does it used? : Sql dba

1056


what is schema? : Sql dba

1147


what is dbms? : Sql dba

1061


Can delete statement be rollbacked?

1054


Do we need to rebuild index after truncate?

1138


how many tables will create when we create table, what are they? : Sql dba

1144


Is primary key clustered index?

1019


what are the advantages of sql ? : Sql dba

1142


How do I remove duplicates in two columns?

1187


Can we use distinct and group by together?

1133


how to escape special characters in sql statements? : Sql dba

1114