select count(*)as adet from
employees
select min(Unitprice)as en_düsük from products
select max(Unitprice)as en_yüksek from products
select sum(Unitsinstock)as toplam from products
select avg(Unitprice)as fiyat_ort from products
select count(distinct Categoryid)as sonuc from products
select * from products where categoryid=3
select products.productname from
categories,products
where categories.categoryname='Confections'
and categories.categoryid=products.categoryid
....
Hiç yorum yok:
Yorum Gönder