GTU DBMS Practical - 4
To perform operations using data manipulation commands, aggregate functions and sorting concept.
1) SQL UPDATE Statement
UPDATE employee
SET emp_sal = emp_sal * 5
WHERE emp_no = '101';
Output
2) COUNT Aggregate Function
SELECT COUNT(*)
FROM employee;
Output
3) AVG Aggregate Function
SELECT AVG(emp_sal)
FROM employee;
Output
4) SQL ORDER BY Keyword
SELECT *
FROM employee
ORDER BY emp_name ASC
Output
5) SQL DELETE Statement
DELETE FROM employee
WHERE dept_no = '20';
Output
