sql select Flashcards
1
Q
What is SQL and how is it different from languages like JavaScript?
A
Declarative language: Describe the result and environment figures it out
2
Q
How do you retrieve specific columns from a database table?
A
select
3
Q
How do you filter rows based on some specific criteria?
A
where
4
Q
What are the benefits of formatting your SQL?
A
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
