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
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is a transaction and why is it important?
Why do we partition data?
What is #temp and @table variable in SQL server?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Who is the owner of a schema in ms sql server?
Explain where clause?
what is denormalization and when would you go for it? : Sql server database administration
Explain features of analysis services?
What is an indexed view?
What is openrowset sql server?
What is the most common trace flags used with sql server?
is there a column to which a default can't be bound? : Sql server database administration