Select DISTINCT Name, city from tblperson
tanlangan kolubdagilarni takrorlanmaydigan qatorlarini chiqarish
tanlangan kolubdagilarni takrorlanmaydigan qatorlarini chiqarish
int va nvarchar li columblarni qo'shib chiqarish uchun int lini nvarcharga o'tqazish kerak
🔥2
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;
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;