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

What is the difference between varchar and varchar types?

0 Answers  

How is table type constraint applied to a table?

0 Answers  

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

Is it possible to update the views? If yes, how, if not, why?

0 Answers  

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

How many types of stored procedures are there in sql server?

0 Answers  

Equi join and non equi join is possible with sql server?

0 Answers  

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

Explain acid?

0 Answers