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
What do you mean by stored techniques? How would we use it?
Which is the main third-party tool used in sql server?
Explain what is the difference between a local and a global temporary table?
What is the purpose of optimization?
Describe in brief sql server monitoring ways.
How optimize sql query with multiple joins in sql server?
What is view in sql?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is a file group?
Explain datetime2 data type in sal server 2008?
What is an inner join?
What are parameterized reports?
Write an SQL query to obtain the 2nd highest salary.
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration