Numeric Functions in SQL | Telugu | uday
HTML-код
- Опубликовано: 20 окт 2024
- 🌐 SQL Project : imyai.in/
💻 SQL Queries from the Video!
👇 Copy these and start practicing now! 🚀
SELECT ABS(-110) AS ABSOLUTEVALUE
SELECT CEIL(20.96)
SELECT AVG(AGE) FROM STUDENTS
SELECT CEIL(AVG(AGE))AS CEILAGE FROM STUDENTS
SELECT FLOOR(20.96)
SELECT ROUND(20.51)
SELECT ROUND(AVG(AGE)) FROM STUDENTS
SELECT TRUNCATE(20.1234,3)
SELECT TRUNCATE(AVG(AGE),1) FROM STUDENTS
SELECT POWER(2,2)
SELECT *, POWER(AGE,3) AS POWERAGE FROM STUDENTS
SELECT *, SQRT(AGE) AS SQRTAGE FROM STUDENTS
SELECT *, TRUNCATE(SQRT(AGE,2)) AS SQRTAGE FROM STUDENTS
SELECT *, EXP(AGE) AS EXPONENTIAL FROM STUDENTS
SELECT *, LOG(AGE) AS LOGARITHMVALUE FROM STUDENTS
SELECT *, LOG(AGE,3) AS LOGARITHMVALUE FROM STUDENTS
SELECT *, LOG10(AGE) AS LOGARITHM FROM STUDENTS
SELECT MOD(5,2)
SELECT MOD(10,2)
SELECT AGE,MOD(AGE,2) AS MODAGE FROM STUDENTS
SELECT SIGN(-1000)
SELECT SIGN(1000)
SELECT SIGN(0000)
SELECT SIGN(AGE) FROM STUDENTS
SELECT PI(1)
SELECT AGE, AGE*PI() FROM STUDENTS
SELECT RADIANS(45)
SELECT AGE, RADIANS(AGE) FROM STUDENTS
SELECT DEGREES(0.3490658503988659)
SELECT GREATEST(10,100,1000)
SELECT LEAST(10,100,1000)
SELECT RAND()
SELECT RAND()*100
SELECT ROUND(RAND()*100) AS RANDOMNUMBER