how to get 25th row in any table in sqlserver can u tell me
syntax
Answer Posted / venkat
suppose the table x having a column with name empid
set rowcount 25
select * from x where empid not in (select top 24 empid
from x)
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How many database files are there in sql server 2000?what are they?
Do you know what is a with(nolock)?
How you can get the list of largest tables in a database?
When would you prefer to have a minimum number of indexes?
What is create command?
How is foreign key related to primary key?
Disadvantages of the indexes?
What is the difference between TRUNCATE and DROP?
What is trigger in salesforce?
How does Report Builder support Analysis Services cubes?
what are constraints? : Sql server database administration
What is Extended user-defined?
Can another user execute your local temporary stored procedures?