February 22, 2025
Sometimes what we’re interested in is just whether or not a row exists. In the example shown, I’m saying I want to select product ID and […]
February 21, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 20, 2025
Another way that we can use a subquery is in place of a list of values. I’ve previously shown how the IN operator allows us to […]
February 19, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A request that I had […]
February 18, 2025
The first example of subqueries types in this series is what’s called a scalar subquery. In this case, I’m trying to work out which orders were […]
February 17, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A request that I had […]
February 16, 2025
Subqueries allow us to reuse data from one query in another query. There are three basic ways that this can work: Row sets (tables) – a […]
February 15, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 14, 2025
We saw in previous post that we had a function called GetRecentOrders that gets the most recent orders for a particular cinema. But what if we […]
February 13, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. I do a lot of […]
February 12, 2025
In previous posts, we’ve seen how to query tables. Another type of object that you might need to query is a table-valued function. Table-valued functions (TVFs) […]
February 11, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]