Locking

Finding all pairs of values where one value is double the other in a SQL table
AskAI

This query will find all pairs of values in a table where one value is double the other.

130
Jan 27
SQL query to return titles of books currently checked out
AskAI

Design a SQL query that will return the titles of all books that are currently checked out from a library catalog.

142
Nov 28
Getting all rows from a table, even if some are locked.
AskAI

This technical problem deals with getting all rows from a table, even if some of the rows are locked. The solution is to write a SQL query that will return all rows from the table.

159
Nov 25
"Tracking which items in a database are currently being edited by which users"
AskAI

The problem is how to design a system to track which items in a database are currently being edited by which users. The input is when a user starts editing an item, and the output is who is currently editing what.

130
Nov 24
SQL query to sum balances of rows with id > 5
AskAI

Write a SQL query to sum the balances of all rows with an id greater than 5.

142
Nov 23
Find all pairs of rows with overlapping start and end times.
AskAI

Given a table of data with three columns: id, start, and end, this SQL query will find all pairs of rows where the start and end times overlap.

124
Nov 20
Number of items locked by each user
AskAI

This technical problem involves writing a query to find the number of items that are locked by each user in a given table. The output should show the user ID and the number of items locked for each user.

119
Nov 20
SQL query to find names of items with price greater than or equal to $10
AskAI

Write a SQL query to find the names of all the items that have a price greater than or equal to $10.

135
Nov 10