sql-select

Question 1

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

Answer 1

Structed Query Language is the primary way of interacting with relational databases; it is a powerful way of retrieving, creating, and manipulating data in a relational database. It is different from JS in that it is declarative, instead of being imperative.

Question 2

How do you retrieve specific columns from a database table?

Answer 2

use select statement and “name” of column

Question 3

How do you filter rows based on some specific criteria?

Answer 3

use the where clause and “name” of column and then and ‘value’ with an operator in-between

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

less than (), greater than, equal to (=), not equal to (!=)

Question 6

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

Answer 6

limit followed by the number

Question 7

How do you retrieve all columns from a database table?

Answer 7

*

Question 8

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

Answer 8

use the order by clause followed by the “name” of column and the keyword (desc for descending; ascending order is default).