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)?
Answer Posted / vishnu
select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Tell me when is the update_statistics command used?
What are data regions?
What do we need queues in sql service broker?
How fixed length strings are truncated and padded?
What are different types of data sources?
What is identity?
what is raid and what are different types of raid configurations? : Sql server database administration
What is the difference between local and global temporary tables?
Ms sql server index?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is inline table-value user-defined function?
Do you know what are different types of replication in sql server?
What are the aggregate and scalar functions?
What is the use of keyword with encryption.
How to apply cascading referential integrity in place of triggers?