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 | 16273 |
| 2. | Jim.Anderson | 8828 |
| 3. | krishnaindia2007 | 8132 |
| 4. | Mohit Sharma | 6752 |
| 5. | Beena | 5371 |
| 6. | jainsourabh2 | 4063 |
| 7. | SriramKrishna | 1857 |
| 8. | Satheesh | 1778 |
| # | 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 |
