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;
@dm3315
2 жыл бұрын
Hi sir, For 2nd ques what happens if we put below query Select * from emp where sal > band_max_sal;
@SurajNaik5459
Жыл бұрын
One of the best guide .....
@arshiyamohammed1914
2 жыл бұрын
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
@Sathwika13
2 жыл бұрын
Select * from where dept_no in ( Select dept_name,max(emp_sal) from employee group by dept_name);
@CK-ir2ke
2 жыл бұрын
You are the full stack ETl guru sir
@rock__14
2 жыл бұрын
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.
@etlqalabs5048
2 жыл бұрын
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
@shireenjm7159
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
@etlqalabs5048
2 жыл бұрын
Please check this .it can clarify some of your questions kzitem.info/news/bejne/qp1uvXiFcqiim4Y
Пікірлер: 23