Advance SQL- First_Value and Last_Value Functions.
This video will explain you working of first_value and last_value function in Advance SQL. Please watch complete video to get useful information and also find attached DDL and DML script for doing handson. Please let me know in comments if you have any queries related to the video.
CREATE TABLE emp (
empno integer,
ename VARCHAR(10),
job VARCHAR(9),
sal integer,
deptno integer,
age integer
);
INSERT INTO emp VALUES (7369,'SMITH','CLERK',800,20,12);
INSERT INTO emp VALUES (7499,'ALLEN','SALESMAN',300,30,16);
INSERT INTO emp VALUES (7521,'WARD','SALESMAN',500,30,21);
INSERT INTO emp VALUES (7566,'JONES','MANAGER',2975,20,18);
INSERT INTO emp VALUES (7654,'MARTIN','SALESMAN',1250,30,31);
INSERT INTO emp VALUES (7698,'BLAKE','MANAGER',2850,30,22);
INSERT INTO emp VALUES (7782,'CLARK','MANAGER',2450,10,27);
INSERT INTO emp VALUES (7788,'SCOTT','ANALYST',3000,20,43);
INSERT INTO emp VALUES (7839,'KING','PRESIDENT',5000,10,38);
INSERT INTO emp VALUES (7844,'TURNER','SALESMAN',1500,30,50);
INSERT INTO emp VALUES (7876,'ADAMS','CLERK',1100,20,55);
INSERT INTO emp VALUES (7900,'JAMES','CLERK',950,30,26);
INSERT INTO emp VALUES (7902,'FORD','ANALYST',3000,20,42);
INSERT INTO emp VALUES (7934,'MILLER','CLERK',1300,10,28);