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 / guest
select top 1 * from table_name where id in(select top 5 id
from table_name order by desc)
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
How to Sync Two SQL Azure Databases?
How to delete all rows with truncate table statement in ms sql server?
Should you normalize audio?
Can multiple columns be used in sql group by clause in ms sql server?
How to count groups returned with the group by clause in ms sql server?
how we use window authentication connection with sql server.?
What is a transact-sql statement batch in ms sql server?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
In what three ways is the return statement used in a stored procedure?
What is dbcc?
What are the advantages of using cte?
Do you know sql server 2008 introduces automatic auditing?
What is the difference between functions and stored procedures?
How you can find out if an index is useful to the optimizer?
How to delete multiple rows with one delete statement in ms sql server?