how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
Answers were Sorted based on User's Feedback
Answer / guest
select top 1 * from table_name where id in(select top 5 id
from table_name order by desc)
Is This Answer Correct ? | 9 Yes | 5 No |
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
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / murthy
to find a nth row in a table
select top n * from <TableName>
except
select top n-1 * from <TableName>
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vishnu
select top 1 * from (select top 5 * from employee order by
empid)sub order by empid desc
Is This Answer Correct ? | 2 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / murthy
declare @n int
set @n=5
select top (@n) * from employees
except
select top (@n-1) * from employees
GO
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sneha s
fetch the 5th record from a table of 10 records:
select * from emp limit 4,1;
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 3 Yes | 4 No |
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)
Is This Answer Correct ? | 1 Yes | 2 No |
There are two methods
1> select top 1(name) from anuppandey
or
2>select top 5o percent name from anuppandey
Is This Answer Correct ? | 3 Yes | 4 No |
Where sql server usernames and passwords are stored in a sql server?
How to fetch the next row from a cursor with a "fetch" statement?
What have included columns when we talk about sql server indexing?
what is the difference between table and view
What is Deadlock?
Explain acid?
What is policy management?
what are the advanced features in sql 2008?
What are locks in sql?
What is the difference between truncate and delete statement?
6 Answers CarrizalSoft Technologies, CTS,
What is difference between delete & truncate commands?
Can select statements be used on views in ms sql server?