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
- 25821 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
How many databases can we create in a single server?
What are the disadvantages of merge replication?
How to fine-tune reports?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is the difference between migration and upgradation in sql server?
What is a trigger and types of a trigger?
What are exact numeric data types in ms sql server?
How to retrieve error messages using odbc_errormsg()?
What are trace flags and mention a few common trace flags used with sql server?
What is sql injection and why is it a problem? : sql server security
How to concatenate two strings in SQL Server.
What are the different types of join?
How raid can influence database performance?
what are candidate key, alternate key and composite key? : Sql server database administration
If a table does not have a unique index, can a cursor be opened on it?
