SQL Select Flashcards
1
Q
What is SQL and how is it different from languages like JavaScript?
A
In declarative languages, programmers describe the results they want and the programming environment comes up with its own plan for getting those results
2
Q
How do you retrieve specific columns from a database table?
A
select and the name of the column
3
Q
How do you filter rows based on some specific criteria?
A
where command
4
Q
What are the benefits of formatting your SQL?
A
to look at the data as efficiently as possible
5
Q
What are four comparison operators that can be used in a where clause?
A
= < > !=
6
Q
How do you limit the number of rows returned in a result set?
A
limit number
7
Q
How do you retrieve all columns from a database table?
A
*
8
Q
How do you control the sort order of a result set?
A
order by
