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
- 25812 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
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
What purpose does the model database server?
Can You Use Data Mining Models In Ssrs?
what is spatial nonclustered index
In which sql server version report builder introduced?
What do you understand by hotfixes and patches in sql server?
Describe in brief sql server monitoring ways.
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are views used for?
What is tempdb database? : SQL Server Architecture
How to recover from sql injection? : sql server security
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Explain different types of lock modes in sql server 2000?
Explain what are the database objects? : SQL Server Architecture
Tell me what is the order in which the sql query is executed?
Please differentiate between a local and a global temporary table?
