Interested to Buy Any Domain ? << Click Here >> for more details...
how to get 25th row in any table in sqlserver can u tell me
syntax
- 8 Answers
- 12073 Views
- I also Faced
- E-Mail Answers
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 the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is recompile sql server?
Explain full-text query in sql server?
What is a primary key?
What is change data capture (cdc) feature?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Which language rdl files made of?
what are isolation levels? : Sql server database administration
What is serializable?
How to count duplicated values in a column in ms sql server?
Define tempdb database?
Can we insert data if clustered index is disabled?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Is mysql better than sql server?
Explain about analysis services?
