SQL Select

Question 1

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

Answer 1

SQL is a programming language used for interacting with relational database management systems. It is different from JavaScript because it is a declarative language.

Question 2

How do you retrieve specific columns from a database table?

Answer 2

You use the select keyword with the names of the columns.

Question 3

How do you filter rows based on some specific criteria?

Answer 3

You use a where clause and the name of the attribute compared against the value you want to filter for.

Question 4

What are the benefits of formatting your SQL?

Answer 4

It makes your code 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

You use the limit keyword and then number of rows to limit to.

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

You use the order by clause and the attribute you want to order by. Default is ascending order