SQL commands

SQL COMMANDS LATEST STUDY GUIDE The SELECT statement is used to select data from a database. The result is stored in a result table, called the result-set. ans: SELECT column_name,column_name FROM table_name; SELECT * FROM table_name; The SELECT DISTINCT statement is used to return only distinct (different) values ans: SELECT DISTINCT column_name,column_name FROM table_name; The WHERE clause is used to extract only those records that fulfill a specified criterion. ans: SELECT co...

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...

The SELECT statement is used to select data from a database. The result is stored in a result table, called the result-set. ans: SELECT column_name,column_name FROM table_name; SELECT * FROM table_name; The SELECT DISTINCT statement is used to return only distinct (different) values ans: SELECT DISTINCT column_name,column_name FROM table_name; The WHERE clause is used to extract only those records that fulfill a specified criterion. ans: SELECT column_name,column_name FROM table_n...

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) SELECT COUNT(Di...