From the course: Learning Azure SQL Querying

Unlock the full course today

Join today to access over 24,500 courses taught by industry experts.

Selecting your new record

Selecting your new record - Azure Tutorial

From the course: Learning Azure SQL Querying

Start my 1-month free trial Buy for my team

Selecting your new record

“

- [Instructor] Look at the results set for the new record that we inserted for the green helmet in the product table. If you wanted to just get the record for the green helmet, there's a much easier way than looking at the entire table and scrolling down to the bottom. And the filter tool we are using within the SQL Editor is a feature of this query editor for filtering the results set. But there's a way we can have SQL do this filtering for us. If you have a value in the filter search, go ahead and delete it. When we open the top 1000 rows of a table, the Azure SQL Query Editor is automatically building this SELECT query for us. It starts with the keyword of SELECT and then uses the keyword of TOP to select the top 1000 rows in the table. You could change this number and rerun the query to get a different number of rows. Then it says *, which means to pull all the columns from the product table. Let's change this query…

Contents