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 is bcnf normalization form?
How to verify a login name with sqlcmd tool?
How to execute multiple stored procedures at one time in sql server?
Why does sql studio use a single registered database repository? : sql server management studio
What are the types of sql server?
Define msdb database?
List few advantages of stored procedure.
How to select true false based on column value in sql server?
Why functions are used in sql server?
How do I perform an unattended install of sql server 2000?
What is schemabinding a view?
What are the joins in sql server? : sql server database administration
How to add more data to the testing table in ms sql server?
How many levels of sp nesting are possible?
What do you mean by sql server 2005 express management tools?