Oracle
Sponsored Links
SQL program given below generates a simple sales report for a year with date, page number displayed at top of report. The SQL program given should be saved in a file named as sample.sql extension and when this file is executed it generates report.
| # | Coder Name | Hits |
| 1. | jamesravid | 37408 |
| 2. | krishnaindia2007 | 31183 |
| 3. | Jim.Anderson | 27775 |
| 4. | Mohit Sharma | 20042 |
| 5. | Beena | 13463 |
| 6. | jainsourabh2 | 8631 |
| 7. | Satheesh | 5676 |
| 8. | SriramKrishna | 4770 |
| # | Coder Name | Codes |
| 1. | jamesravid | 3 |
| 2. | Mohit Sharma | 2 |
| 3. | Satheesh | 1 |
| 4. | jainsourabh2 | 1 |
| 5. | SriramKrishna | 1 |
| 6. | krishnaindia2007 | 1 |
| 7. | Beena | 1 |
| 8. | Jim.Anderson | 1 |
