identity ga misol

Identity columb yaratish

Select DISTINCT Name, city from tblperson
tanlangan kolubdagilarni takrorlanmaydigan qatorlarini chiqarish

select bilan ishlatiladigan operatorlar

int va nvarchar li columblarni qo'shib chiqarish uchun int lini nvarcharga o'tqazish kerak

#Select 1

SELECT CASE
WHEN A + B > C AND B + C > A AND A + C > B THEN
CASE
WHEN A = B AND B = C THEN 'Equilateral'
WHEN A = B OR B = C OR A = C THEN 'Isosceles'
ELSE 'Scalene'
END
ELSE 'Not A Triangle'
END
FROM TRIANGLES;