sql-select

Question 1

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

Answer 1

SQL is a declarative programming language.

Question 2

How do you retrieve specific columns from a database table?

Answer 2

By using “select” keyword and the column’s name within double quote.

Question 3

How do you filter rows based on some specific criteria?

Answer 3

Using the “where” keyword followed by a comparison.

Question 4

What are the benefits of formatting your SQL?

Answer 4

Readability.

Question 5

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

Answer 5

=
!=
>

Question 6

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

Answer 6

Using the “keyword” limit and a number for the limit.

Question 7

How do you retrieve all columns from a database table?

Answer 7

Using * with the “select” keyword.

Question 8

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

Answer 8

By adding a “desc” for descending or leave blank of ascending.