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

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024
  • #etlqalabs #etl #sqlinterviewquestionsandanswers #linux
    ETL Testing | Tricky SQL queries | Second Highest Salary department wise
    Playlists for your reference:
    ETL Testing Tutorial for begginers and advanced level :
    • ETL Testing
    SQL Tutorial for begginers and advanced level :
    • SQL Tutorial for Begin...
    Linux Tutorial for beginners and advanced level:
    • Linux for Testers
    Data Warehousing Tutorial for beginners and advanced level:
    • Data Warehousing concepts
    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.

ความคิดเห็น • 11

  • @UmeAsh393-z4d
    @UmeAsh393-z4d 2 ปีที่แล้ว +1

    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
      @etlqalabs5048  2 ปีที่แล้ว

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

  • @rajeshthota2699
    @rajeshthota2699 2 ปีที่แล้ว

    Thank you Sir 🙏

  • @Harshal_chaudhari15
    @Harshal_chaudhari15 2 ปีที่แล้ว

    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.

  • @kartikjuneja7807
    @kartikjuneja7807 2 ปีที่แล้ว +1

    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.

  • @niraj74chavan
    @niraj74chavan 2 ปีที่แล้ว

    Nicely explain.
    This can be achieved by dense_rank also

  • @jangamlaxmangoud6194
    @jangamlaxmangoud6194 2 ปีที่แล้ว

    How to calculate percentage of student marks ?

  • @srinivasmg3385
    @srinivasmg3385 2 ปีที่แล้ว +2

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

  • @tousifalisarwan5130
    @tousifalisarwan5130 2 ปีที่แล้ว

    First view