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
- 21521 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 coalesce and check constraint in sql server?
What is exclusive locks?
Difference between group by clause and having clause in SQL?
What is the difference between count and distinct count?
How will you find out if there are expensive SQL statements running or not?
Tell me in brief how sql server enhances scalability of the database system?
What is the difference between varchar and nvarchar?
How to get a list of columns in a view using "sys.columns" in ms sql server?
Explain collation?
What is the datatype of rowid?
New concepts of sql server 2005 use in your project.
What are diverse clauses that form a part of sql?
What is catalog views?
What are the steps to process a single select statement?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
