Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
9.12.2020
create table Produs( idprodus integer, denumire varchar(20), pret integer, furnizor varchar(20), TVA integer, 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'), (115, 'Mercedes', 42, 'Seria 124214213'), (116, 'Aschii', 444, 'Trei_Brazi_SRL'), (117, 'Alt_Duster', 540, 'Dacia'); DELETE FROM Produs WHERE pret >= 100; update Produs set Pret = Pret + (pret * 1/10) where Furnizor = 'Trei_Brazi_SRL'; select denumire, furnizor from Produs order by denumire asc , furnizor asc; select pret from Produs order by pret desc; select denumire, pret from Produs where pret>=10 and pret<=100 and furnizor='Trei_Brazi_SRL'; select denumire, pret from Produs where furnizor='Trei_Brazi_SRL' or furnizor='Dacia'; 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 (12, 113, 117, 5); select sum(cantitate) as cantitatevanzare from Vanzare, Produs where vanzare.idprodus=produs.idprodus and produs.denumire='ALT_DUSTER'; 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 (113, 'PO', 'PA', 'China', '24059587234'), (114, 'C', 'KA', 'China', '1231237'), (115, 'A', 'KA', 'China', '1231237'), (116, 's', 'KA', 'Japonia', '07070707'), (117, 'qwe', 'K', 'China', '24059587234'), (118, 'd', 'KA', 'China', '1231237'), (119, 'we', 'KA', 'China', '1231237'), (120, 'Ba', 'wsA', 'Japonia', '07070707'), (121, 'c', 'we', 'Korea', '24059587234'), (123, 'Bqwe', 'KA', 'Japonia', '07070707'), (124, 'Bwesd', 'K', 'China', '24059587234'); select top 10 nume, prenume from Client order by nume asc , prenume asc; select nume, prenume, telefon from Client; select distinct judet from Client; select count (*) as numarclienti from Client; select count (idclient) as numarclientidinchina from Client where judet='china'; select * from Client;
run
|
edit
|
history
|
help
0
Sum then delete one row
abhishek
OUTER JOIN
Greatest_N_Per_Group
search all tables for string
bc160401882
Exam_2_Final
omnichannel_example
Employye
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...