Cursor: Give a Raise
Hard
Procedural SQL
Write a procedure that uses a cursor to give a 10% raise to every employee earning less than 50000, one row at a time.
Table schema
Employees(id INT PRIMARY KEY, name VARCHAR(50), salary INT)Sample data
id | name | salary
1 | Amy | 40000
2 | Ben | 60000
3 | Cara | 45000
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.