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 | 37411 |
| 2. | krishnaindia2007 | 31184 |
| 3. | Jim.Anderson | 27780 |
| 4. | Mohit Sharma | 20046 |
| 5. | Beena | 13463 |
| 6. | jainsourabh2 | 8631 |
| 7. | Satheesh | 5677 |
| 8. | SriramKrishna | 4771 |
| # | 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 |
