sql-select

Question 1

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

Answer 1

SQL is a declarative language like HTML and CSS where we give input and receive output .. where with javascript we give it step by step instruction

Question 2

How do you retrieve specific columns from a database table?

Answer 2

SELECT “columnName”

Question 3

How do you filter rows based on some specific criteria?

Answer 3

WHERE “columnName” comparison “specificCriteria”

Question 4

What are the benefits of formatting your SQL?

Answer 4

makes code easy to read

Question 5

What are four comparison operators that can be used in a where clause?

Answer 5

equals
less than
greater than
not equal to

Question 6

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

Answer 6

LIMIT

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

ORDER BY “whatever column name is” ASC/DESC