SQL-ebi

arsebul monacemTa bazidan saWiro informaciis amoReba (“SQL”-is
gamoyenebiT)
SeiyvaneT Semdegi “queries” sistemaSi da SeasruleT isini:
1. SELECT *
FROM DEPT_LOCATIONS AS dl;
2. SELECT *
FROM EMPLYEE As e
WHERE e. SEX= “F”;
3. SELECT *
FROM DEPARTMENT AS d, DEPT_LOCATIONS AS dl;
daakvirdiT Sedegs, fiqrobT rom sasurveli Sedegi miiReT? Tu ara, SeecadeT SecvaloT
is.
4. SELECT e.FNAME, e. LNAME, e.DNO
FROM EMPLYEE As e
WHERE e. DNO= 5;
SQL queries
SQL QUERY1
warmoadgineT yevla im TanamSromlis saxeli, gvari, misamarTi, sqesi, vinc me-5
departamentSi muSaobs.
SQL QUERY2
warmoadgineT yvela im qali TanamSromlis saxeli da gavari, romlebic me-5
departamentSi muSaoben. SeianxeT es versia saxeliT “Query2a”, Semdeg gansazRvreT
sxva “query” saxeliT “Query2B”, igive pirobiT, magarm cxrili “Employee”-s nacvlad
miuTiTeT “Query2a”.
SQL QUERY3
1
warmoadgineT yvela im qali TanamSromlis gvari, mismarTi da xelfasi, romlebic
gamoimuSavben 30,000$-ze met Tanxas da yvela im kaci TanamSromlis gvari,
mismarTi da xelfasi, romlebic gamoimuSavneb 45,000$-ze met Tanxas, SinaxeT es
“query” “Query3a”-is saxeliT.
arsebobs am “query”-is gansazRvris alternatiuli gza, ori “SELECT”-is da “UNION”-is
gamoyenebiT, SeinaxeT es “query” “Query3b”-s saxeliT.
SQL QUERY4
moipoveT yvela TanamSromlis saxeli , romlebsac yavT supervaizeri.
SQL QUERY5
gaimeoreT “query1” –is piroba, magram me-5 departamentis nacvlad miuTiTeT
departamenti :”Research”.
SQL QUERY6
yvela proeqtisTvis, romlebic hiustonSi mdebareobs warmoadgineT proeqtis nomeri,
maTi makontrolebeli departamentis nomeri, maTi menejerebis socialuri usafrTxoebis
nomeri.
SQL QUERY7
yvela proeqtisTvis, romelic mdebareobs strafordSi warmoadgineT makontrolebeli
departamentis nomeri, departamentis menejeris gvari, misamarTi da dabadebis TariRi.
SQL QUERY8
warmoadgineT im proeqtebis saxelebis da adgilmdebareobis sia, romlebic mdebareoben
imave qalaqebSi, sadac maTi makontrolebeli departamentebi. (gamoiyeneT mxolod ori
cxrili, ara sami)
SQL QUERY9
warmoadgineT im TanamSromlebis saxelebi, romlebic muSaoben me-20 nomer proeqtSi.
2
SQL QUERY10
warmoadgineT im TanamSromlebis saxelebi, romlebic ar muSaoben me-20 nomer
proeqtSi.
3