SQL select Flashcards
1
Q
What is SQL and how is it different from languages like JavaScript?
A
A declarative language, you tell it what you want now how to do it
2
Q
How do you retrieve specific columns from a database table?
A
select “column name”
3
Q
How do you filter rows based on some specific criteria?
A
where “column” (comparison operator) ‘filter’
4
Q
What are the benefits of formatting your SQL?
A
readability
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 (#)
7
Q
How do you retrieve all columns from a database table?
A
Select *
8
Q
How do you control the sort order of a result set?
A
Order by (criteria)
9
Q
How do you skip a certain amount of entries before sending it back
A
Offset
