ETL Testing : SQL queries based Interview questions and answers - 1

#etlqalabs #etl #sqlinterviewquestionsandanswers #linux

Playlists for your reference:
ETL Testing Tutorial for begginers and advanced level :

SQL Tutorial for begginers and advanced level :

Linux Tutorial for beginners and advanced level:

Data Warehousing Tutorial for beginners and advanced level:

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.

[ShivShwetaVlogs]

Thanks for discussing these questions... 😊😊 Very much helpful for interviews

[aditideshmukh]

Sir, min Or max is not to be used in question where we need to find min salary. We can use select * from (select row_number() over (partition by name order by salary asc) as the_val from table) as N where N.the_val = 1

[bhargavakotakonda]

Thank you so much sir,
For helping us

[ShivShwetaVlogs]

Hi Sir, please add this question in your next upcoming video, , SQL Query Top 1 selling product from last 10 days

[sireeshareddy-nr]

Thanks for this video. I have one question
If we have more than 5 lakh records how can we check data loaded from src to tar ??

[ashokrajann]

Set operators can be used between 2 tables only right??

[chandanmohanty]

Sir, I have 1 doubt at the play run time 36:59 where during odd retrieval we are getting emp no 10, 12 and 14 also. But they are even not odd. Am i miss understood something? Can u please help me

[deveshpadgelwar]

Table A (Student ID, Student Name, Student Age)
table B (Student ID, Student Class, Student Section)
Select Student Name, Student Class, Student Section where Student Age between 16 to 18 and Student Section is 'D' How to find out sir ?