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 will add additional conditions in sql?
What is ms sql server service broker?
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the transaction properties?
What are the advantages of sql azure?
Explain about the command-line tool SQLCMD?
What is database isolation in sql server? : sql server database administration
How do I create a stored procedure in dbml?
What is snapshot report?
What are the ways available in sql server to execute sql statements?
What happens if ntwdblib.dll is missing on your machine?
What is the full form of dql?
What do you mean by recursive stored procedure?
How do I find query history in sql server?
Explain how does the report manager work in ssrs?