Hetu ji, Can you please verify if we can also use below query for the 4th question: select salary,dept from (select salary,dept,ROW_NUMBER() over(partition by dept order by salary desc) as rn from emp)where rn=2;
Yeah, It's very important questions in interview. So useful sir Can u also explain using substring questions. For example visayaa. In these, a is reapting thirce. Question is Count of A Have to print A alone
Hi Sir, for the last question we can use Union All function right.? Decode will decode the data so I think it might give wrong ans if we mention multiple columns in select statement. Please correct me if I'm wrong.
Actually good attempt but union all is similar to union which will result the output in ascending order but our requirement is to display in the order like 1 3 2 So we have to used decode in order by clause
One of the best guide .....
You are the full stack ETl guru sir
Hetu ji,
Can you please verify if we can also use below query for the 4th question:
select salary,dept from (select salary,dept,ROW_NUMBER() over(partition by dept order by salary desc) as rn from emp)where rn=2;
& finally understood the use of decode function 👍keep making content like this
Yeah, It's very important questions in interview. So useful sir
Can u also explain using substring questions. For example visayaa.
In these, a is reapting thirce.
Question is
Count of A
Have to print A alone
Please check this .it can clarify some of your questions
ruclips.net/video/Ig8WDO9vqhQ/видео.html
LENGTH('VISAYAA') - LENGTH (REPLACE('VISAYAA', 'A', '')
Select * from dual where REGEXP_LIKE('VISAYAA','^A');
For count of A
We can do using length
super sir. Thanks for this video .
Hi sir, For 2nd ques what happens if we put below query
Select * from emp where sal > band_max_sal;
For 3rd question
Select * from emp Max(sal) group by dept; can't we write this if we want to display all the columns of table
Select * from where dept_no in
(
Select dept_name,max(emp_sal) from employee group by dept_name);
Hi Sir, for the last question we can use Union All function right.?
Decode will decode the data so I think it might give wrong ans if we mention multiple columns in select statement.
Please correct me if I'm wrong.
Actually good attempt but union all is similar to union which will result the output in ascending order but our requirement is to display in the order like
1
3
2
So we have to used decode in order by clause
Why we need to case or decode in order by
We can use in select list
Sir,
Please explain about
Difficult Bug handled so far
Difficult transformation rule you have felt so far
Production error and root cause analysis
Sir please explain about string functions
Please watch this
ruclips.net/video/Ig8WDO9vqhQ/видео.html
Sir ple explain about subquery topic.. 🙏
HI SIR please help me a question answer
1-find out nth highest highest salary deptment wise using dense rank() and not using dense rank ?
Hello Sir,
could we use subquery with not in for 2nd max salary.
Yes - you can use "not in" instead < , both will yield same result