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
What are the new features in sql server 2016?
What is partitioned view?
What is used to replicate sessions between instances in coldfusion clusters?
What is an identity column in insert statements?
What is coalesce and check constraint in sql server?
How to get nth highest salary from employee table.
What is data source document?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What the different components of Replication and what is their use?
Is it important for a database administrator to understand the operating system and file access?
What is scrollable cursor?
What is data mart? : sql server analysis services, ssas
Differentiate between sql temp table vs table variable?
What is difference between createstatement and preparedstatement?
How to copy data from one table to another table?