SQL commands
Las últimas cargas en SQL commands. ¿Buscando notas en SQL commands? Tenemos muchas notas, guias de estudio y notas de estudio disponsible para tu escuela.
-
7
- 0
-
2
All courses for SQL commands
-
SQL commands 7
Último contenido 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...
- Examen
- • 7 páginas's •
-
SQL COMMANDS•SQL COMMANDS
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...
- Examen
- • 14 páginas's •
-
SQL commands•SQL commands
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...
- Examen
- • 7 páginas's •
-
SQL COMMANDS•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) 
SELECT COUNT(Di...
- Examen
- • 14 páginas's •
-
SQL commands•SQL commands