how to get 25th row in any table in sqlserver can u tell me
syntax
Answer Posted / a.alagu ganesh
We create index colomn in that table . use that index
coloum we take the 25th row of that table .
Example
SELECT * FROM table1 WHERE index_coloumn = 25
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How to list all triggers in the database with sys.triggers in ms sql server?
Explain the relational database management system (rdbms)?
How to rebuild master databse?
How can you start sql server in different modes?
What is a partitioned view?
Will the writetext statement activate a trigger?
What is a dataset and what are the different types of datasets?
How many servers can we create in a single subscription?
What is normalization? Explain different forms of normalization?
What is an index in a database?
Differentiate between ms sql server reporting services vs crystal reports?
What are commit and rollback in sql?
What is the difference between an index and a unique index?
What are extended events in sql server?