Podcast
Questions and Answers
What is the correct SQL syntax to create an alias for a column?
What is the correct SQL syntax to create an alias for a column?
Which SQL clause is used to filter groups created by a GROUP BY statement?
Which SQL clause is used to filter groups created by a GROUP BY statement?
What keyword is used to sort the result set in descending order?
What keyword is used to sort the result set in descending order?
Which type of JOIN returns all records from the left table and matched records from the right table?
Which type of JOIN returns all records from the left table and matched records from the right table?
Signup and view all the answers
What does the AVG function in SQL compute?
What does the AVG function in SQL compute?
Signup and view all the answers
Which SQL statement correctly uses the LIKE operator?
Which SQL statement correctly uses the LIKE operator?
Signup and view all the answers
What will the following SQL statement return? SELECT Column_name FROM table_name WHERE Column_name BETWEEN Value1 AND Value2;
What will the following SQL statement return? SELECT Column_name FROM table_name WHERE Column_name BETWEEN Value1 AND Value2;
Signup and view all the answers
Which of the following SQL statements is correctly structured to check for the existence of a record?
Which of the following SQL statements is correctly structured to check for the existence of a record?
Signup and view all the answers
Study Notes
SQL Commands
-
ALIAS: Creates an alias for a column using the
ASkeyword.- Example:
SELECT column_name AS alias_name FROM table_name;
- Example:
SQL GROUP BY
-
GROUP BY: Groups rows that have the same values in specified columns.- Example:
SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) ORDER BY column_name(s);
- Example:
SQL HAVING
-
HAVING: Filters groups of rows based on a condition.- Example:
SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) HAVING condition ORDER BY column_name(s);
- Example:
SQL ORDER BY
-
ORDER BY: Sorts the result set in ascending (ASC) or descending (DESC) order.- Example:
SELECT column1, column2 FROM table_name ORDER BY column1 ASC, column2 DESC;
- Example:
SQL JOINS
-
INNER JOIN: Returns rows where the values in specified columns match in both tables.- Example:
SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name;
- Example:
-
LEFT JOIN: Returns all rows from the left table, and the matching rows from the right table.- Example:
SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;
- Example:
-
RIGHT JOIN: Returns all rows from the right table, and the matching rows from the left table.- Example:
SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;
- Example:
-
FULL JOIN: Returns all rows from both tables, combining matching rows and rows with no match in the other.- Example:
SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;
- Example:
SQL FUNCTIONS
-
AVG(): Calculates the average of a numeric column.- Example:
SELECT AVG(column_name) FROM table_name WHERE condition;
- Example:
-
SUM(): Calculates the sum of a numeric column.- Example:
SELECT SUM(column_name) FROM table_name WHERE condition;
- Example:
-
COUNT(): Counts the number of rows or values in a column.- Example:
SELECT COUNT(*) FROM table_name; - Example:
SELECT COUNT(column_name) FROM table_name;
- Example:
-
MIN(): Finds the minimum value in a numeric column.- Example:
SELECT MIN(column_name) FROM table_name WHERE condition;
- Example:
-
MAX(): Finds the maximum value in a numeric column.- Example:
SELECT MAX(column_name) FROM table_name WHERE condition;
- Example:
SQL WHERE Clause
-
LIKE: Matches values based on a pattern.- Example:
SELECT column1, column2 FROM table_name WHERE column1 LIKE '%abc%';
- Example:
-
IN: Matches values within a specific set of values.- Example:
SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...);
- Example:
-
BETWEEN: Matches values within a specified range.- Example:
SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2;
- Example:
-
ANY/SOME: Compares a value to any/some value in a subquery.- Example:
SELECT column_name FROM table_name WHERE column_name > ANY (SELECT column_name FROM another_table);
- Example:
-
EXISTS: Checks if a subquery returns any rows.- Example:
SELECT column_name FROM table_name WHERE EXISTS (SELECT 1 FROM another_table WHERE condition);
- Example:
-
AND,**OR,**NOT: Combines conditions using logical operators.
Boolean Operators
-
AND: ReturnsTRUEif both conditions areTRUE. -
OR: ReturnsTRUEif at least one condition isTRUE. -
NOT: Returns the opposite of the condition.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Test your knowledge on SQL commands like ALIAS, GROUP BY, HAVING, and ORDER BY. This quiz will help you understand how to manipulate and retrieve data efficiently from databases using SQL. Perfect for students and professionals looking to sharpen their database skills.
