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 / murthy
declare @n int
set @n=5
select top (@n) * from employees
except
select top (@n-1) * from employees
GO
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between mongodb vs. Sql server?
Define tool Manage Statistics in SQL Server 2000 query ?
What are a scheduled jobs or what is a scheduled tasks?
What is the maximum number of index per table?
Can one drop a column from a table?
What is the function of sql server agent windows service?
How to specify the collation for a character data type in ms sql server?
Explain datetime2 data type in sal server 2008?
What is dirty read?
What is difference between inner join and join?
Explain the difference between delete,drop and truncate in SQL Server?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain about unique identifier data type in sql server?
What do you understand by a view?
How do I setup a local sql server database?