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

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?

0 Answers  

What are tables in sql server?

0 Answers  

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

What is collation sensitivity?

0 Answers  

How to provide Security for package?

1 Answers   Convergys,

How can delete duplicate records in cte in sql server?

0 Answers  

How to add a new dsn with the odbc driver for sql server?

0 Answers  

How to sort the query output with order by clauses in ms sql server?

0 Answers  

What are the components of dbms?

0 Answers  

Explain system rowset functions?

0 Answers  

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers