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
- 26254 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many cores do I need for sql server 2016?
How do I perform an unattended install of sql server 2000?
Write query to return all rows sql?
What are the five major components of a dbms?
What are the advantages of user-defined functions over stored procedures in sql server?
What is Cross Join and in which scenario do we use Cross Join?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain different types of self contained sub query?
What does the on delete cascade option do?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
Explain system rowset functions?
What do you mean by the term 'normalization'?
What are entities and relationships?
Explain microsoft sql server functions?
Explain raiserror in sql server?
