Stored Procedures

Get unique values from a table column
AskAI

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.

158
Jan 30
Get total number of employees in each department
AskAI

Write a stored procedure that returns the total number of employees in each department from a given table of employee data.

132
Nov 26
Return the name and salary of the highest paid employee from a table of data.
AskAI

Write a stored procedure that returns the name and salary of the highest paid employee from a table of data.

172
Nov 22
Find the number of days between two dates using a stored procedure
AskAI

This stored procedure calculates the number of days between two dates.

155
Nov 18
Get Customer Name and Address by ID
AskAI

The stored procedure will take in a customer ID as input and return the customer's name and address.

153
Nov 15
Stored Procedure for Returning Employee Names, Job Titles, and Salaries with...
AskAI

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.

161
Nov 14
Get Top 10 Products by Sales
AskAI

Write a stored procedure that returns the top 10 products by sales from a given table.

157
Nov 05
SQL Query to Count Total Orders per Customer
AskAI

Write a SQL query to return the total number of orders for each customer from a given table.

158
Nov 01