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
- 26305 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
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Explain the difference between cross join and full outer join?
When is the use of update_statistics command?
How to list all field names in the result set using mssql_field_name()?
Distinguish between nested subquery and correlated subquery?
Explain how to integrate the ssrs reports in application?
What are the advantages of sql azure?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What are cursors in ms sql server?
What is cte (common table expression)?
Explain ranking functions?
Why and when do stored procedure recompile?
What are the five major components of a dbms?
Is the primary key column of a table an index in ms sql server?
How to assign null values to variables or columns?
