Interested to Buy Any Domain ? << Click Here >> for more details...
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)?
- 16 Answers
- 26309 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
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
What is a trigger and types of a trigger?
What is the difference between online clustering and Offline clustering?
What are the three different part of rdl file explain them?
How can sql server instances be hidden?
Explain isolation levels that sql server supports?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the maximum size of sql server database?
How to set database to be single_user in ms sql server?
Where are sql server user names and passwords stored in sql server?
What is a ddl statement?
How to read data in a table with "select" statements?
How will you make an attribute not process? : sql server analysis services, ssas
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is the difference between a primary key and a unique key? Are they the same?
