how to get 25th row in any table in sqlserver can u tell me
syntax

Answer Posted / sujitha

For Example TableName: Employee. Employee Have The
Following Fields.
Emp_No ( Identity Value)
Emp_Name
Designation



Select Top 1 * From Employee Where Emp_No Not in(Select
Top 24 Emp_No From Employee)

Is This Answer Correct ?    13 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me the disaster recovery plan

2027


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

556


What is sql server 2000 work load governor?

556


What is PROJECTION Operation?

611


What is the maximum number of index per table?

567






Can we take the full database backup in log shipping?

544


How to manipulate data from one table to another table ?

549


difference between Clustered index and non clustered index ?

581


what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

540


What is Extended user-defined?

537


How to compare the top two records using sql?

768


What is buffer cash and log cache in sql server?

593


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

535


What is the process of normalization?

562


Do you know sql server 2008 backup compression?

568