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:
info@cloudchallengers.com
Follow us on
Instagram : instagram.com/cloudchallengers
Facebook : facebook.com/cloudchallengers
LinkedIn : linkedin.com/company/cloudchallengers
On this page of the site you can watch the video online WIPRO SQL Interview Question - FIRST_VALUE( ) Function with a duration of hours minute second in good quality, which was uploaded by the user Cloud Challengers 25 July 2024, share the link with friends and acquaintances, this video has already been watched 27,710 times on youtube and it was liked by 658 viewers. Enjoy your viewing!
