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
- 26298 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
Explain about Normalization?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How many replicas are maintained for each sql azure db?
What to check if a User database is locked?
What the different components of Replication and what is their use?
What is autocommit mode in sql server?
How many categories of functions based their return modes?
Explain isolation levels that sql server supports?
How to make a remote connection in a database?
Write a sql query to delete duplicate records from a table called table1
How to create nested stored procedure?
Why are views required in the sql server or in any other database?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is conditional split?
What are user-defined functions (udfs) in sql server?
