1: Module 3 SIMPLE SQL QUERIES
2: Agenda SELECT … FROM DISTINCT ORDER BY SELECT … FROM … WHERE IN, BETWEEN, LIKE, NOT NULL VALUE DATE AND TIME
3: SELECT … FROM Main SQL commands to extract data from database tables: SELECT FROM SELECT , , … FROM For example: SELECT CITY FROM DEPARTMENT SELECT ID, NAME FROM STUDENT
4: COMPANY database
5: DEMONSTRATION Demo 1
6: ORDER BY The ORDER BY keyword is used for sorting the result set by one or more columns. To sort the records in a descending order, we can use the DESC keyword. For example SELECT NAME FROM DEPARTMENT ORDER BY NAME DESC
7: DISTINCT
8: WHERE The WHERE clause is used to extract only those records that fulfill a specified criterion SELECT FROM WHERE Comparison operators: , , ,
9: DEMONSTRATION Demo 3
10: IN, BETWEEN The IN operator allows you to specify multiple values in a WHERE clause. For example SELECT FIRSTNAME, LASTNAME FROM EMPLOYEE WHERE POSITION IN (MANAGER, SELLER)
11: LIKE The LIKE operator is used in a WHERE clause to search for a specified pattern in a column In SQL, wildcard characters are used with the SQL LIKE operator Wildcard characters - a substitute for zero or more characters - a substitute for a single character
12: NOT NOT operator is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement. NOT CONDITION For example SELECT CITY FROM DEPARTMENT WHERE NOT CITY LIKE Lviv
13: NULL value NULL values represent missing unknown data. IS NULL IS NOT NULL For example SELECT LASTNAME, FIRSTNAME FROM EMPLOYEE WHERE BONUS IS NULL
14: DEMONSTRATION Demo 4
15: Working with DATE type DATEPART(datepart, date) DAY(date) MONTH(date) YEAR(date) DATEDIFF(datepart, startdate, enddate)
16: Thank you!