Stored Procedures

Categories: Code Problem / Data Structures and Algorithms / Recursion (32) Code Problem / Data Structures and Algorithms / Binary Search (30) Code Problem / Data Structures and Algorithms / Linked Lists (26) Code Problem / Data Structures and Algorithms / Backtracking (26) Code Problem / Data Structures and Algorithms / Stacks and Queues (25) Code Problem / Data Structures and Algorithms / Hashing (24) Databases / SQL / Backup and Recovery (19) Code Problem / Data Structures and Algorithms / Arrays and Strings (19) Databases / SQL / Database Normalization (18) Code Problem / Data Structures and Algorithms / Time Complexity (17) Databases / SQL / Locking (16) Databases / SQL / Replication (15) Databases / SQL / SQL Queries (13) Code Problem / Data Structures and Algorithms / Graphs (13) Databases / SQL / Database Security (13)  More...

Recent solutions:

Check these solutions from our community:
Databases / SQL DifficultyHard SQL
This stored procedure will take in a table name and column name as input, and return all the unique values in that column as output.
About this solution: The solution above is optimal because it uses the DISTINCT keyword to return only unique values.
Jan 30
Databases / SQL DifficultyHard SQL
Write a stored procedure that returns the total number of employees in each department from a given table of employee data.
About this solution: This solution is correct and demonstrates a good understanding of SQL.
Nov 26
Databases / SQL DifficultyHard SQL
Write a stored procedure that returns the name and salary of the highest paid employee from a table of data.
About this solution: The candidate's solution is correct and demonstrates a good understanding of how to solve the problem. The approach is efficient and uses a subquery to find the maximum salary, which is then used to return the name and salary of the employee with that salary.
Nov 22
Databases / SQL DifficultyMedium SQL
This stored procedure calculates the number of days between two dates.
About this solution: This solution is correct and efficient.
Nov 18
Databases / SQL DifficultyMedium SQL
The stored procedure will take in a customer ID as input and return the customer's name and address.
About this solution: The candidate's solution is complete and solves the problem. The approach is straightforward and efficient.
Nov 15
Databases / SQL DifficultyMedium SQL
This problem asks the user to write a stored procedure that returns the name, job title, and salary of the employees with the highest salaries.
About this solution: This solution is correct and demonstrates a good understanding of SQL.
Nov 14
Databases / SQL DifficultyMedium SQL
Write a stored procedure that returns the top 10 products by sales from a given table.
About this solution: The candidate's solution is optimal and demonstrates a complete understanding of how to write a stored procedure to return the top 10 products by sales.
Nov 05