Selecttop (15)percent*fromSales. OrderDetails select*fromSales. OrderDetails

selecttop (15)percent*fromSales.OrderDetails

select*fromSales.OrderDetails

where productid in(72,51,41)and qty in(10, 20)

select name,count(name)from students

groupby name

SELECTcustid,empid,shipcountry,COUNT(*)ASsoniFROMSales.OrdersWHERE

custidIN(85, 84, 34)ANDempidIN(3,4,5,6)AND
shipcountryIN('France','Belgium','Brazil')
GROUPBYcustid,empid,shipcountry
havingCOUNT(*)> 1
SELECTorderid,orderdate,custid,empid
FROMTSQL2012.Sales.Orders
ORDERBYorderdate,orderid
OFFSET 50 ROWSFETCHNEXT 25 ROWS ONLY

substring('Maktab sinflari',8,4),

left('Maktabsinflari', 4),
right('Maktabsinflari', 4),
len('Maktabsinflari '),
datalength('Maktabsinflari '),
patindex('%sinf%','Maktabsinflaribfhesgjhshbgkshlysinf'),
charindex('sinf','Maktabsinflarifvbdskhvhbdsvjknkhsbvhjsinf', 9)

delete students where id in(3,9)

delete studentswhereid<= 10

union va Union all

join va left join lar birbiridanqandayfarqqiladi

right join vafull outer join lar birbiridanqandayfarqqiladi

qaysifinksiyalaragregatfunksiyalar