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
Explain query editor regions
How to test subquery results with the exists operator?
How to manipulate data from one table to another table ?
How to create a user name in a database?
What are the differences between DDL, DML and DCL in SQL?
How do I shrink an ldf file?
Define full outer join?
What is history table in sql server?
What is an index. What are the types?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is a collation?
why would you call update statistics? : Sql server database administration
What is an indexing technique?
What is default constraint in ms sql server?
What is implicit cursors?