SQL RANK Functions in Detail | Window Functions | Important SQL Interview Question | SQL Analytics

Published: 05 October 2023
on channel: Data Project Hub

240

In this video we learn about SQL Rank functions.

SQL provides SQL RANK functions to specify rank for individual fields as per the categorizations. It returns an aggregated value for each participating row. SQL RANK functions also knows as Window Functions. We will see more about the following functions in this video:
➡️ROW_NUMBER()
➡️RANK()
➡️DENSE_RANK()
➡️NTILE()

🖥️DDL and DML for the table used in the video:

CREATE TABLE examresult
(StudentName VARCHAR(70), Subject VARCHAR(20), Marks INT);

INSERT INTO ExamResult VALUES
('Lily', 'Maths', 65),
('Lily', 'Science', 80),
('Lily', 'english', 70),
('Isabella', 'Maths', 50),
('Isabella', 'Science', 70),
('Isabella', 'english', 90),
('Olivia', 'Maths', 55),
('Olivia', 'Science', 60),
('Olivia', 'english', 89);

#sql #sqlinterview #dataanalytics #sqlserver #sqldatabase #datascience #sqlinterviewquestionsandanswers #sqlinterviewquestion #datascience #rank #sqlfullcourse #sqlfunctions
‪@dataprojecthub‬

On this page of the site you can watch the video online SQL RANK Functions in Detail | Window Functions | Important SQL Interview Question | SQL Analytics with a duration of hours minute second in good quality, which was uploaded by the user Data Project Hub 05 October 2023, share the link with friends and acquaintances, this video has already been watched 240 times on youtube and it was liked by 17 viewers. Enjoy your viewing!

16,802