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
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Write the SQL query to drop, truncate and delete table.
What is the meaning of sql server?
What is acid db?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What is a non clustered primary key?
What is transaction server distributed transaction?
Write an SQL query to obtain the 2nd highest salary.
What are different types of replication in sql server?
What are transactions in sql?
What are the character string functions supported by sql server 2005?
What is row_number () and partition by in sql server?
How to download microsoft sql server 2005 express edition?
How to use group functions in the select clause in ms sql server?
Write a sql query to get zero records from a table having n number of records?