sql-select

Question 1

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

Answer 1

scripted query language - it is declarative - you declare what you want to do and it will figure out how to do it

Question 2

How do you retrieve specific columns from a database table?

Answer 2

you use the select statement and the columns name in double quotes

Question 3

How do you filter rows based on some specific criteria?

Answer 3

you use the where clause

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

you use the limit clause

Question 7

How do you retrieve all columns from a database table?

Answer 7

you use the asterisk

Question 8

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

Answer 8

order by clause and desc if you want