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
What is data source object?
Explain relational data?
What is the default port for SQL Server over a firewall?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Can a unique index be created on a column, which contains null?
Do you know what are the ways available in sql server to execute sql statements?
What are the types of indexes?
What is checkpoint process in the sql server?
What is the difference between osql and query analyzer?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is code near application topology?
Write a sql query to get zero records from a table having n number of records?
what's the difference between delete table and truncate table commands? : Sql server database administration
How to find the list of fixed hard drive and free space on server?