Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Pana la ex 7, inclusiv
create table Produs( idprodus integer, denumire varchar(100), pret integer, furnizor varchar(20), primary key (idprodus)); insert into Produs(idprodus, Denumire, Pret, Furnizor) values (111, 'Duster', 10000, 'Dacia'), (112, 'BMW', 10001, 'Seria 3'), (113, 'Audi', 80, 'Seria 1'), (114, 'Lemne', 45, 'Trei_Brazi_SRL'); DELETE FROM Produs WHERE pret >= 100; update Produs set Pret = Pret + (pret * 1/10) where Furnizor = 'Trei_Brazi_SRL'; select * from Produs; create table Vanzare( idvanzare integer, idclient integer NOT NULL, idprodus integer NOT NULL, cantitate integer NOT NULL, primary key (idvanzare)); insert into Vanzare(idvanzare, idclient, idprodus, cantitate) values(11, 112, 1, 2); ALTER TABLE Vanzare DROP COLUMN cantitate; select * from Vanzare; create table Client( idclient integer, nume varchar(100) NOT NULL, prenume varchar(100) NOT NULL , judet varchar(20) NOT NULL, telefon varchar(20) NOT NULL, adresa varchar(20), primary key (idclient)); insert into Client(idclient, nume, prenume, judet, telefon) values (112, 'Ba', 'KA', 'Japonia', '07070707'), (113, 'B', 'K', 'China', '24059587234'), (114, 'C', 'KA', 'Korea', '1231237'); select * from Client;
run
|
edit
|
history
|
help
0
Lab 4
Lab assessment 2
add loopback linked server
Finding Row Wise Max Value From Table
megha
Shalvika's Query
generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql
megha
SinghDestiny
Demo