Interested to Buy Any Domain ? << Click Here >> for more details...
how to select 5 to 7 rows from a table, which contains 10 rows?
- 21 Answers
- 26331 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s. ramesh
select * from ( select rownum r, comp_name from metatest )
where r > 4 and r < 8;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to create percentile function?
What is exporting utility?
Explain about Normalization?
What are secondary xml indexes?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Explain ms sql server reporting services vs crystal reports?
What is sql server locking?
What does Master database contains?
What does the update command do?
How can you set the threshold at which sql server will generate keysets asynchronously?
Explain Geography datatype in SQL Server
How to integrate the ssrs reports in application?
Can You Use Data Mining Models In Ssrs?
What is BCP? When does it used in sql server 2012?
Other than truncate statement, which other command can by-pass the trigger on the tables?
