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 are the restrictions that views have to follow?
What are group functions in query statements in ms sql server?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What are the main differences between #temp tables and @table variables and which one is preferred?
What are the differences between having and where clause.
What is a schema in ms sql server 2005?
Do you know what is lock escalation?
What is a cache in ssrs?
How to set database to be single_user in ms sql server?
How to create a user to access a database in ms sql server using "create user" statements?
What is the command to change the recovery model?
Can multiple columns be used in sql group by clause in ms sql server?
How exceptions can be handled in sql server programming?
Does group by or order by come first?
Explain full-text indexing?