Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 26256 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 information is maintained within the msdb database? : Sql server administration
What is rtm version in sql server?
What is the difference between NOROW and LOCKROW?
Can you get second highest salary from the table?
What are the types of database recovery models?
Difference between group by clause and having clause in SQL?
How to end a stored procedure properly in ms sql server?
Explain the steps to create and execute a user-defined function in the sql server?
how to define testing of network layers? : Sql server database administration
Can I use sql azure as a backup with log shipping or database mirroring?
What is a file group?
List out some of the requirements to set up a sql server failover cluster?
What is meant by referential integrity?
How to get the number of affected rows?
What is the process of indexing?
