Recent posts
Find all rows where value in column 2 is greater than value in column 1
AskAI
SQL Problems
This query will find all the rows in a table where the value in the second column is greater than the value in the first column.
SQL query to find products locked more than three times
AskAI
SQL Problems
This SQL query will find the products that have been locked more than three times.
Get the Top 3 Most Expensive Items in Each Category
AskAI
SQL Problems
This technical problem involves writing a SQL query that returns the top 3 most expensive items in each category.
Users Who Have Logged In from Multiple IP Addresses
AskAI
SQL Problems
This technical problem involves writing a SQL query to find all user IDs that have logged in from more than one IP address.
SQL Query to Find Top 3 Most Purchased Products by Customers
AskAI
SQL Problems
This technical problem involves writing an SQL query that returns the top 3 most purchased products by customers. The example input and output are provided.
SQL Query to Find Most Recent Backup of Each Database on Server
AskAI
SQL Problems
Write a SQL query to find the most recent backup of each database on a server.
Find Username from User ID and Password
AskAI
SQL Problems
Given a table with user_id, username, and password columns, and a list of user_id and password pairs, write a query to find the username for each user_id in the list.
Summing Even Numbers in an Array
AskAI
SQL Problems
This technical problem deals with creating a function that will take in an array of integers and return the sum of all the even numbers in the array.