Oracle
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 | 16255 |
| 2. | Jim.Anderson | 8820 |
| 3. | krishnaindia2007 | 8126 |
| 4. | Mohit Sharma | 6745 |
| 5. | Beena | 5366 |
| 6. | jainsourabh2 | 4058 |
| 7. | SriramKrishna | 1854 |
| 8. | Satheesh | 1775 |
| # | 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 |
