sql-select

Question 1

What is SQL and how is it different from languages like JavaScript?

Answer 1

Declarative language, we tell it what to do and it figures out how to do it

Question 2

How do you retrieve specific columns from a database table?

Answer 2

Select statement, select keyword, columns

Question 3

How do you filter rows based on some specific criteria?

Answer 3

where clause followed by condition

column and table names: “”
values: ‘’

Question 4

What are the benefits of formatting your SQL?

Answer 4

• standardized
• legible
• easier to debug

Question 5

What are four comparison operators that can be used in a where clause?

Answer 5

! = , <> Not equal
> , > = Greater than, greater than or equal to
< , < = Less than, less than or equal to
BETWEEN … AND … Inclusive of two values

Question 6

How do you limit the number of rows returned in a result set?

Answer 6

limit clause

Question 7

How do you retrieve all columns from a database table?

Answer 7

select *

Question 8

How do you control the sort order of a result set?

Answer 8

order by

will sort by default A-Z/0-9
-use desc to reverse