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 the authentication mode can be changed?

0 Answers  

Which is faster statement or preparedstatement?

0 Answers  

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

What is a fill factor?

0 Answers  

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

What do you mean by sql server 2005 express management tools?

0 Answers  

What is transaction server distributed transaction?

0 Answers  

Describe in brief system database.

0 Answers  

What are distributed partitioned views?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers