how to get 25th row in any table in sqlserver can u tell me
syntax
Answer Posted / svreddy
select *from emp a where 25=(select count(distinct(eno))from emp b where a.eno>=b.eno
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What types of replication are supported in sql server?
Can foreign key be deleted?
How to integrate the ssrs reports in application?
what stored procedure would you use to view lock information? : Sql server administration
Explain the advantages of merge replication?
Where are sql server usernames and passwords stored in the sql server?
What are the different types of locks in the database?
Can we add an identity column to decimal datatype?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is difference between view and materialized view?
Where can you find the error log information? : sql server database administration
What is a db view?
How to delete all rows with truncate table statement in ms sql server?
What is optimistic concurrency?