课程: SQL for Testers

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Getting started with SQL queries

Getting started with SQL queries - SQL教程

课程: SQL for Testers

开始一个月试用 购买团队方案

Getting started with SQL queries

“

- [Instructor] In the last video I had you type in and execute a query. You might not have understood exactly what this query is all doing, but now we're going to dive into this and understand what's actually going on. So the query we have here is pretty simple. We just wrote select star from fake car data. Now, let's just walk through this one step at a time. So first we have this select statement, which well, it selects data, and then we have the star here. So the asterisk or star is a wild card character. It essentially means give back data from all the columns in this table. So we could change this to be a column name, and then we'd only get data from that column. So for example, we could put last_name as the name of this column. We get back a table with only that one column, only the last name column in it. I'll just change this back to star for now, consider. So we'll send that query off and you can see that the response we get back only has the rows where the vehicle make is…

内容