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
- 25245 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 logical operators in sql server?
What are ddl triggers and types of ddl trigger?
What are the new data types are introduced in sql 2000?
What is the difference between deallocate cursor and close cursor?
How to delete database objects with "drop" statements in ms sql server?
Does a specific recovery model need to be used for a replicated database? : sql server replication
How to create an identity column?
What are the differences between decimal and float in ms sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain what is the use of custom fields in report?
What is update_statistics command?
What is the simplest way to create a new database in ms sql server?
What is transactional replication?
How to find the list of fixed hard drive and free space on server?
