Top 6 SQL interview question | sql interview questions and answers |Tricky sql query in oracle

#etlqalabs #etl #sqlinterviewquestionsandanswers #linux #sql Dear friends, In this video, i have discussed popular SQL interview questions based on GROUP BY and HAVING clause | Top 6 SQL query | sql interview questions and answers | SQL Interview Preparation 1) Find all the department number whose total salary is more than 50000; 2) Find the duplicate records/rows in the table 3) Find only non-duplicate rows in the table 4) Find all the department number whose minimum salary is less than 10000; 5) Find all the department number whose minimum salary is less than 10000 except department no 103; 6) Find all the duplicate empno from the employee table Playlists for your reference: ETL Testing Tutorial for begginers and advanced level : https://www.youtube.com/playlist?list=PLz5n9ljUmyOyUuD9RhtqX0moDAZIaQxVj SQL Tutorial for begginers and advanced level : https://www.youtube.com/playlist?list=PLz5n9ljUmyOx7rlTVWQvhWqZ4giecLOqT Linux Tutorial for beginners and advanced level: https://www.youtube.com/playlist?list=PLz5n9ljUmyOyqdouKrzj_RpRsiALUN6Tn Data Warehousing Tutorial for beginners and advanced level: https://www.youtube.com/playlist?list=PLz5n9ljUmyOz53-xM0NMWV4aDp1SGFvG6 Hey Guys, If you’re enjoying this video and you’d like to support this channel, please do to consider subscribe this channel! It might seem small, but hitting that subscribe button helps alot and means more contents in future.