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
- 25852 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
Is mysql the same as sql server?
How do I view a procedure in sql server?
How do I find query history in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How to write an inner join with the where clause in ms sql server?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Can we call stored procedure in trigger?
Do you know what is a with(nolock)?
Does partitioning help performance?
Write a query for primary key constraint with identity key word?
What Are the Main Features of SQL Azure?
Explain the difference between function and stored procedure?
When cursors are useful?
What is a ddl statement?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
