SQL Intro and SQL Select

Question 1

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

Answer 1

SQL is adeclarativeprogramming language. In declarative languages, programmersdescribethe results they want and the programming environment comes up with its own plan for getting those results.

Question 2

How do you retrieve specific columns from a database table?

Answer 2

Use the select keyword followed by the name of the column

Question 3

How do you filter rows based on some specific criteria?

Answer 3

Use the select and where clause; expression that evaulates to true or false

Question 4

What are the benefits of formatting your SQL?

Answer 4

For 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

Keyword limit followed by a number for the number of rows

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

Keyword order by column name ___ (default is ascending) and if want descending put desc