how to get 25th row in any table in sqlserver can u tell me
syntax
- 8 Answers
- 9898 Views
- I also Faced
- E-Mail Answers
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
How do I run a trace in sql server?
What is the difference between Normalization and De-normalization?
What is the difference between a "where" clause and a "having" clause?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How do you improve the performance of a SQL Azure Database?
How many instances per computer are there in sql server 2000?
what's the difference between a primary key and a unique key? : Sql server database administration
Can we return Data from 4(more than 1) tables in stored procedure?
How to change a login name in ms sql server?
What is difference between foreign key and unique key?
How to execute stored procedure and set temp table in sql server?
What is the name of reporting services config file and what’s it’s used for?
How is a full-text index updated?
What is a domain constraint give an example?
Explain isolation levels that sql server supports?
