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 is temporal data type?
what is blocking? : Sql server database administration
Is sql server 2016 free?
Explain an automatic checkpoint
How connect excel to sql server?
Tell me when is the update_statistics command used?
Is sql server a database?
What is raid and what are different types of raid levels?
How to count duplicated values in a column in ms sql server?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
How can you check the version of sql server?
How to trouble shoot if unable to connect SQL Server
Why truncate is ddl?
What do you mean by a Composite primary key?
What is bcp? When does it use?