second test Flashcards
Group by
Order by
GROUP BY groups by a requested attribute
ORDER BY places the attribute in a certain order
Where
Having
HAVING is used to check conditions after the aggregation takes place.
WHERE is used before the aggregation takes place.
table
view
TABLE contains all of the data / values
VIEW is a select statement that user can view selected attributes
update
alter
UPDATE allows changing of info
ALTER changes the structure of the table
drop
delete
DROP deletes the table data and structure of the table
DELETE deletes the table data but keeps the structure
rollback
to undo previous transactions, use the rollback clause
set
use set when you want to change an SQL environmental variable
where
to limit the number of rows retrieved by the query use the where clause
distinct
use distinct to prevent duplicate names from being displayed in the results
select
enter the specific columns you want to display
/
executes the SQL statement currently in the buffer
L
list the SQL statement currently in the buffer
;
terminates an SQL statement
@
symbol used to run a script file
!
passes a command to the operating system