Interested to Buy Any Domain ? << Click Here >> for more details...
A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 28362 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / intelligent
select * from emp where rownum>101 and rownum<121
| Is This Answer Correct ? | 2 Yes | 18 No |
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What are the two types of exceptions.
How to use sql statements in pl/sql?
What is the difference between explicit and implicit cursors in oracle?
explain the delete statements in sql
What is difference between joins and union?
How many databases can sql express handle?
How much does a sql dba make? : SQL DBA
What is a 'instead of trigger'?
Does sql profiler affect performance?
What are all the common sql functions?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
