WIPRO SQL Interview Question - FIRST_VALUE( ) Function

One of the SQL questions recently asked in WIPRO interview. We need to Find department wise minimum salary empname and maximum salary empname . To solve this, we will write a query by using FIRST_VALUE() windows function for first approach and Rownumber() function for second approach. Create table syntax CREATE TABLE emps_tbl (emp_name VARCHAR(50), dept_id INT, salary INT); INSERT INTO emps_tbl VALUES ('Siva', 1, 30000), ('Ravi', 2, 40000), ('Prasad', 1, 50000), ('Sai', 2, 20000), ('Anna', 2, 10000); For more SQL interview questions. Check out our playlist.    • SQL Interview Questions   Contact us: [email protected] Follow us on Instagram : instagram.com/cloudchallengers Facebook : facebook.com/cloudchallengers LinkedIn : linkedin.com/company/cloudchallengers