Answer / senthilkumar

SELECT TOP 1 Empid
FROM (SELECT DISTINCT TOP 6 Empid FROM Employees ORDER
BY Empid desc) a ORDER BY Empid asc

Answer / vamsi krishna

select * from <table name> order by <column name> limit 0,5;
or
select * from <table name> limit 0,5;

Answer / owen

-- I believe the questionner wants the 5th row
-- (only) from the data.
-- I also assume we don't have a useful ID to work with.
-- This is one way of doing it without cursors:

select top 1 <fieldname>
from <TableName>
where <fieldname> not in
(select top 5 <fieldname>
from <TableName>)

-- NB Changing the "5" in the subquery above sets which
-- row number is returned

Answer / ashim pal

set rowcount 5

select * from table_name

Answer / ritu saini

SELECT TOP 5 column FROM table
ORDER BY NEWID()

Answer / sruthi

select top5 * from table
minus
select top4 from table

How to find the login name linked to a given user name?

0 Answers  

What is index, cluster index and nonclustered index?

0 Answers  

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

List some advantages and disadvantages of stored procedure?

0 Answers  

What happens if an integer is too big for int date type?

0 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

What is dbcc?

0 Answers  

Why use stored procedures in sql server?

0 Answers  

Questions regarding Raiseerror?

1 Answers  

What is the system function to get the current user's user id?

3 Answers   TCS,

How to loop through returning rows?

0 Answers  

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

0 Answers