how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
- 16 Answers
- 21548 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / lince thomas
it is simple,
we can get 5th row using this,
select * from (
select rank() over (order by Empid)as rno,* from empmast)T
where T.rno=5
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is deploy, process and build? : sql server analysis services, ssas
List out the difference between union and union all in sql server?
What is the boxing and unboxing concept in .net?
Explain what are the database objects? : SQL Server Architecture
What is sql profiler. What are the default templates with it? : sql server database administration
How to download microsoft sql server 2005 express edition?
What is the difference between dropping a database and taking a database offline?
What is the process of normalising?
What is surrogate key? : sql server analysis services, ssas
How to drop an existing table?
How to encrypt data between dialogs?
Explain what are magic tables in sql server?
What is the sql server agent?
Define compound operators?
What are different types of schemas?
