sql select

Question 1

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

Answer 1

Structured Query Language

backend language used for interacting with relational databases

declarative like HTML/CSS, JS is imperative

Question 2

How do you retrieve specific columns from a database table?

Answer 2

select “column1”,
“column2”
from “table”;

Question 3

How do you filter rows based on some specific criteria?

Answer 3

select “column1”,
“column2”
from “table”
where “columnName” = ‘string’;

Question 4

What are the benefits of formatting your SQL?

Answer 4

consistency, easier to read

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

select “column1”,
“column2”
from “table”
limit max; // max is an integer

Question 7

How do you retrieve all columns from a database table?

Answer 7

select *

from “table”

Question 8

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

Answer 8

select *
from “table”
order by “columnName”;