SQL commands





AVG() ans: SELECT AVG(COLUMN NAME) FROM TABLE_NAME

Using it in WHERE CLAUSE so a different form of presentation:

TO LIST ONLY THOSE PRODUCTS AND PRICES WHERE THE AVERAGE IS MORE THAN A SPECIFIC AMOUNT:-

SELECT ProductName, Price FROM Products

WHERE Price>(SELECT AVG(Price) FROM Products);



COUNT() ans: SELECT COUNT(*) FROM TABLE_NAME

(to select all the NON null values of records in the table

SELECT COUNT(Column Name) FROM TABLE_NAME

(to count all values in a column...
CIBTAC Written Exam Questions AND ANSWERS
CIDESCO 141 Questions With Complete Solutions
CIDESCO: Skin Analysis questions and answers
PPME Block 1-7 (test-bank) / Primary Professional Military Education (Enlisted) Block 1 to 7/ Complete solution guide, A+ Rated
PPME Block 1-7 (test-bank) / Primary Professional Military Education (Enlisted) Block 1 to 7/ Complete solution guide, A+ Rated