sql-select

Question 1

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

Answer 1

powerful way to retrieve, create, and manipulate data in a relational databases.
(structured query language)

SQL is a declarative programming language. meaning the programmers describe the results they want and the programming environment comes up with its plans to get that result. (example: CSS and HTML) –> example: you put the property and value to make the font bigger.

relational databases interpret SQL and comes up with the most efficient plan to get the results from the programmers command lines.

Question 2

How do you retrieve specific columns from a database table?

Answer 2

using the keyword “select” and “from”.

Question 3

How do you filter rows based on some specific criteria?

Answer 3

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

=, < , > and !=

Question 6

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

Answer 6

limit Clause

Question 7

How do you retrieve all columns from a database table?

Answer 7

select * (astrix)

Question 8

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

Answer 8

order by (option descending)