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
- 23435 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 a rollup clause?
what is a join and explain different types of joins? : Sql server database administration
What is the recursive stored procedure in sql server?
Are null values the same as that of zero or a blank space?
Can we take the full database backup in log shipping?
Explain how to use linked server?
What is the default Port No on which SQL Server listens?
What is the data tier application?
Explain iaas, paas and saas?
What is difference between drop truncate and delete?
What are the different types of join?
How to write a query with an inner join in ms sql server?
What is equi join with example?
What is key attribute?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
