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 reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

What is GUID in sql server?

0 Answers   BirlaSoft,

How many categories of data types used by sql server?

0 Answers  

Do you know what are the steps to process a single select statement?

0 Answers  

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

What is inline variable assignment?

0 Answers  

What is raid and what are different types of raid levels?

0 Answers  

what operator performs pattern matching?

2 Answers  

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers