SQL Flashcards
Datatypes?
char(n),varchar(n),integer,raw/blob,clob,date
How to create a table?
create table variable(variable data attribute
how to add data?
insert into VARIABLE(data,data)
values(x,x)
How to slect?
select x,x
from Variable, variable
where m=”given”
delete syntax?
delete variable
where variable> x
What is distinct
prevent elimination
update syntax
update variable
set this=this
Types of SQL
Sorting, duplication elimination, relationalgebra,tupelvariable, operation
sorting
order by??desc/asc
Aggregation functions
count() sum(),min()max()
IN operator
retrieve all data/table where the values is there
quantiziert - exist
select x
from x
where exists
why is correleated better as korrelierted
it is more independent and more efficient as it is execute once
between and in?
between x and x;
in(x,x,xx);
explain “%”,”;”,”_”
%-belieb zeilen lieke,sname like T%ccc;
_genau 1 zahl