ETL Testing | Tricky SQL queries | Second Highest Salary department wise

[@s_s3825]

Sir, your videos are extremely helpful to us. I would greatly thankful it if you could provide sample data for all the questions. Thank you!

[@rajeshthota2699]

Thank you Sir 🙏

[@niraj74chavan]

Nicely explain. This can be achieved by dense_rank also

[@srinivasmg3385]

select * from( select salary,deptno,dense_rank() over(partition by deptno order by salary desc)rnk from emp) where rnk=2;

[@kartikjuneja7807]

I also find this query much easier.

[@Harshal_chaudhari15]

Can you explain this to me please??

[@UmeAsh393-z4d]

Sir if source system is in CSV and Excel file or in different db how can I validate the data iscorrect or not? Before migration and after migration?

[@etlqalabs5048]

Please check my python pandas series, i have covered file validation there.

[@kartikjuneja7807]

Hello Sir, Can you please make a video on this? We have Team1 Team2 Winner columns in a table called matches: Team1 Team2 Winner Ind Aus Ind Aus NZ NZ Nz SA SA SA ENG ENG ENG PAK PAK 1) How many matches are played By IND 2) How many matches were played 3) what are the teams where at least matches were played. 4) what are the teams where at least matches were won.

[@Harshal_chaudhari15]

Sir, how can we update the second-highest salary department-wise by 1000? Please answer 🙏 I am trying to solve this query for the week.

[@jangamlaxmangoud6194]

How to calculate percentage of student marks ?

[@tousifalisarwan5130]

First view