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 objects does the fn_my_permissions function reports on? : sql server security
What is sql or structured query language?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What happens if strings are casted into wrong code pages in ms sql server?
Explain sql server service broker?
Difference between connected and disconnected database in .net with sql server?
What are the different types of backups avaialabe in sql server 2005?
Explain the truncate command?
What are the basic features of a trigger in ms sql server?
When you should use a low fill factor?
What happens if null values are involved in bitwise operations?
What are different types of statement?
What is the current limitation of the size of SQL Azure DB?
What is mean by candidate key?
How do triggers work?