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 / senthilkumar
SELECT TOP 1 Empid
FROM (SELECT DISTINCT TOP 6 Empid FROM Employees ORDER
BY Empid desc) a ORDER BY Empid asc
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How to name query output columns in ms sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is sql view?
What is database replication? What are the different types of replication you can set up in sql server?
Explain steps of normalization?
What is table-valued sub query?
What is trace flag in sql server?
Define clusters?
What command would you use to create an index?
What is logshipping and its purpose?
What is difference between line feed ( ) and carriage return ( )?
How to create a new table in a given schema?
Why is replication required on the sql server?