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)?
Answer Posted / 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
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
What is “asynchronous” communication in sql server service broker?
How to modify an existing user defined function?
What is the difference between stored procedure and user defined functions?
Is sql server 2016 free?
How to write a query with a right outer join in ms sql server?
What is implicit mode in sql server?
how to create “alternate row colour”?
Does the order of columns in update statements matter?
What are different types of data sources?
What is a performance monitor?
How to rename an existing column with sql server management studio?
How to run queries with sql server management studio express?
What is dml command?
What is report rendering ?