Select top (15) percent from Sales. OrderDetails select from Sales. OrderDetails

select top (15) percent * from Sales.OrderDetails

select * from Sales.OrderDetails

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

select name, count(name) from students

group by name

SELECT custid, empid, shipcountry, COUNT(*) AS soni FROM Sales.Orders WHERE

custid IN(85, 84, 34) AND empid IN(3,4,5,6) AND
shipcountry IN('France', 'Belgium', 'Brazil')
GROUP BY custid, empid, shipcountry
having COUNT(*) > 1
SELECT orderid, orderdate, custid, empid
FROM TSQL2012.Sales.Orders
ORDER BY orderdate, orderid
OFFSET 50 ROWS FETCH NEXT 25 ROWS ONLY

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

left('Maktab sinflari', 4),
right('Maktab sinflari', 4),
len ('Maktab sinflari '),
datalength('Maktab sinflari '),
patindex('%sinf%', 'Maktab sinflari bfhesgjh shbgkshly sinf'),
charindex('sinf','Maktab sinflari fvbdskhvh bdsvjkn khsbvhj sinf', 9)

delete students where id in (3,9)

delete students where id <= 10

union va Union all

join va left join lar bir biridan qanday farq qiladi

right join va full outer join lar bir biridan qanday farq qiladi

qaysi finksiyalar agregat funksiyalar