SQL is the "meat and potatoes" of data analysis for many people—used it's to access, clean, and analyse data contained in databases. It's simple to understand, but it's used by the world's top corporations to tackle extremely difficult problems.
CUME_DIST (Transact-SQL)
FIRST_VALUE (Transact-SQL)
LAG (Transact-SQL)
LAST_VALUE (Transact-SQL)
LEAD (Transact-SQL)
PERCENT_RANK (Transact-SQL)
PERCENTILE_CONT (Transact-SQL)
PERCENTILE_DISC (Transact-SQL)
An analytic function gives a single output for each row after computing values across a collection of rows. An aggregate function, on the other hand, delivers a single result for a group of rows.
SQL Server comes with a wide range of mathematical functions. These math functions are specialised to Trigonometry, Calculus, and Geometry applications. ABS, CEILING, DEGREES, FLOOR, POWER, RADIANS, and SIGN are arithmetic functions that return a value of the same data type as the input value.
Learner's Ratings
4.6
Overall Rating
77%
14%
5%
0%
4%
Reviews
Y
Yadav Aakash
5
very useful thank you learnvern
A
Ashish
5
The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.
N
nayazbasha sk
5
very useful thank you learnvern
M
Mahima Patel
5
very usefull......thanks
P
Priya Kushwaha
5
Very Good trainer
C
chanchal singh
5
you guys are doing nice job. thanks
U
Umesh Wankhede
5
Not too much interactive
M
Monesh Ram
5
Well Explained in Every Chapters..
G
GAJANAN DIGAMBAR MODE
5
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
Share a personalized message with your friends.