How to select nth record from a table?
Answer Posted / andy
select a.id,a.name from dept a
where
1= (select COUNT(b.id) from dept b where b.id>a.id)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is Federation Root Database?
What are the types of database recovery models?
Can we linked SharePoint to a SQL database?
How do you test your database? : sql server database administration
How to turn off warning messages during php execution?
whats new about truncate in sql server 2008?
Describe in brief system database.
Explain different forms of normalization?
Can we shrink data file in sql server?
Which are the new data types introduced in sql server 2008?
What happens if you insert a duplicate key for the primary key column in ms sql server?
How to use subqueries in the from clause in ms sql server?
What number sorts of privileges are accessible in sql?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration