sql-select-Q&A

Question 1

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

Answer 1

SQL is a declarative programming language, programmers describe the 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

Select “Name of column”

Question 3

How do you filter rows based on some specific criteria?

Answer 3

where “Name of column” = “Name of row”

Question 4

What are the benefits of formatting your SQL?

Answer 4

Database tables in large systems can contain millions of rows. As humans we cannot really understand that much information all at once. Plus, the types of problems that we are solving usually involve a few pieces of data at a time.

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

limit (number of rows)

Question 7

How do you retrieve all columns from a database table?

Answer 7

The * (asterisk) operator

Question 8

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

Answer 8

Order by