Answer / guest

select top 1 * from table_name where id in(select top 5 id
from table_name order by desc)

Answer / uma

this is uma sorry the above is wrong.


pls the is the correct answer ,i have this answer

declare cursor on table ,after that open the cusor and
using "fetch" keyword we retrive any row ,and we have
remove the cursor explictly because it is stored in the
memory pls use dellocate keyword


declare cursou_emp2 insensitive scroll cursor for select *
from empdetails [for{readonly}]

open cursou_emp2


fetch absolute 15 from cursou_emp2


deallocate cursou_emp2




it will display 15th row, if u wnt any row u chnage instead
of 15

Answer / murthy

to find a nth row in a table

select top n * from <TableName>
except
select top n-1 * from <TableName>

Answer / vishnu

select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc

Answer / lince thomas

it is simple,
we can get 5th row using this,


select * from (
select rank() over (order by Empid)as rno,* from empmast)T
where T.rno=5

Answer / murthy

declare @n int
set @n=5
select top (@n) * from employees
except
select top (@n-1) * from employees
GO

Answer / sneha s

fetch the 5th record from a table of 10 records:
select * from emp limit 4,1;

Answer / kishor

select top 1 * from table_name
where id in (select top 5 id from table_name order by id asc)
order by id desc

Answer / uma

all the answers are wrong,the questions is like this there
are 100 rows they want o/p to display is in betwwen 50 and
100 are displayed


select top 100 * from tablename where empid not in(
select top 50 empid from TABLENAME)

Answer / anup kumar pandey

There are two methods
1> select top 1(name) from anuppandey
or
2>select top 5o percent name from anuppandey

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

What are pages and extents? : SQL Server Architecture

0 Answers  

Explain transaction server isolation?

0 Answers  

how to know description of a table in sqlserver 2000

8 Answers  

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

How do you rebuild an identity column?

0 Answers  

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

What are the types of subquery?

0 Answers  

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

Explain about nested stored procedure?

0 Answers