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

What is the benefit of normalization?

0 Answers  

Explain the difference between function and stored procedure?

0 Answers  

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

Tell me what do we need queues in sql service broker?

0 Answers  

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

what is checksum in sql server.........???

0 Answers   TCS,

How to update multiple rows with one update statement in ms sql server?

0 Answers  

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers  

What does the automatic recovery do?

1 Answers  

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

How to compare the top two records using sql?

0 Answers  

What is an expression in ms sql server?

0 Answers