Interested to Buy Any Domain ? << Click Here >> for more details...
how to get 25th row in any table in sqlserver can u tell me
syntax
- 8 Answers
- 12081 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
suppose the table x having a column with name empid
set rowcount 25
select * from x where empid not in (select top 24 empid
from x)
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is the template in sql?
Explain “@@rowcount” and “@@error” in sql server?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is the report model project?
What is the security model used in sql server 2005?
Can coalesce return null?
Explain the difference between delete,drop and truncate in SQL Server?
How fixed length strings are truncated and padded?
Explain activity monitors
Do you know what is openxml in sql server?
What is the security principal at the server level that represents your session?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the export options of ssrs?
Why Master database is required?
