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 / 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
explain how to create a new schema in a database? : Sql server database administration
How do I run a trace in sql server?
When does a workload on SQL Azure get throttled?
In which format does an image save in SQL Server database ?
What are the properties of the relational tables?
What is the concept of optimization?
How can you start sql server in different modes?
what changed between the previous version of sql server and the current version? : Sql server database administration
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What are acid properties of transaction?
What is snapshot replication?
Is it important for a database administrator to understand the operating system and file access?
What is the command to change the recovery model?
What is a data source or ds? : sql server analysis services, ssas
Should you normalize audio?