Oracle interesting questions and answers | SQL to find the N th maximum salary

[@saktibiswal6445]

Subscribed!! Awesome Channel and very good explanation! Definitely learnt from this

[@SivaAcademy]

Thank you 💐

[@bhaskaro]

Thanks for explaining different methods to find the N'th max salary, also please make a video which methods of these are efficient.

[@mukeshchitte3870]

Great, happy to listen to u, thanks a lot 🙂

[@SivaAcademy]

My pleasure, thank you 💐💐🙏

[@Ram-tf8ir]

Great work❤

[@abheshkumar2232]

Write a procedure to update salary 10% and select employees. Without using parameters.

[@sansurvase2]

You are Amazing ! 👏👏🙌

[@SivaAcademy]

Thank you bro

[@manideepkumar959]

1st rownum u explained well, later ur simply typing something and not explaining what r u writing,in subquery why r u writing b.sal>=a.sal?

[@anushaa1471]

Sir, thank you for this GREAT VIDEO👍. Could you please elaborate the method 3 approach .? Why we are taking count of distinct salary there?

[@AparnaBL]

Lady since there is a duplicate salary 10000. He mentioned twice same point 🤔🤔🤔🤔🤔😏

[@sujaa1000]

Thanks again Siva!

[@SivaAcademy]

My pleasure!

[@deepakranjanmishra3]

Sir very good explanations.Thank you so much for your extended support to make it.Much appreciated.

[@SivaAcademy]

Welcome 🙏💐💐

[@crazycom9807]

Thanks a lot for such a detailed explanation..

[@SivaAcademy]

Thank you

[@manikandanpanneer1650]

Thanks Dear Bro 🙏🙋‍♂️😍

[@SivaAcademy]

Welcome bro 🙏

[@rajasekarp7873]

👍Super bro👏

[@SivaAcademy]

Thank you

[@devinenibalaji9038]

Hi siva , Request to pls clearly explain the subquery method

[@kapilsrivastava8007]

Excellent answer

[@SivaAcademy]

Welcome bro 💐

[@SatyendraSingh-ul5iq]

Thanks shiva, please let us know that difference between force view and inline view.

[@SivaAcademy]

Ideally we should not compare both, posted both cocepts seperalty

[@pra1bhus1]

Great content. I don't know who is the one disliked this video

[@SivaAcademy]

Thank you 💐

[@vsr1727]

Thank you siva👍

[@SivaAcademy]

Welcome

[@minicat1983]

Or use nth_value function Select distinct nth_value(sal,5) over (order by sal desc range between unbounded preceding and unbounded following) rn From emp;

[@sravankumar3674]

Hi .... Any video which will return multiple rows using object type in function?

[@tshende02]

Thank you so much

[@SivaAcademy]

You're most welcome

[@Pmreedy801]

Great sir ,😍😍

[@SivaAcademy]

Thank you 💐

[@dfhwze]

Can you also do it using match_recognize or a recursive function?

[@PrayasDhanbadBasicBuilder]

Seems fetch first don't work in 11g. So kindly do mention the oracle version. If possible in each video.

[@SriLife2]

Can u do the same to find group wide nth sal without rank, analytical, rownum functions.

[@SivaAcademy]

No, for finding group wise salary, analytical function is the best approach

[@ravipatisrikanth8331]

Sir ,how to find difference between salaries in emp table

[@SivaAcademy]

Differences between what two salaries??

[@ravipatisrikanth8331]

No two salaries, you can 5 or 6 salaries like 2000,1800,1600,1000,800

[@ravipatisrikanth8331]

I know how to find out the difference between two salaries but I don't know how to find out more than two salaries

[@ravipatisrikanth8331]

One guy asked in my interview

[@ravipatisrikanth8331]

So please write a query sir

[@sumanthreddy1139]

sir can i have latest recorded videos if i pay u the money..

[@SivaAcademy]

Hi Sumanth, no need to pay, I was not feeling good last couple of weeks, will be start posting from next week onwards, please stay tuned

[@sampurnabhattacharjee9748]

will this query work for the above question Select Salary FROM(SELECT DISTINCT SALARY FROM EMPLOYEE ORDER BY Salary DESC FETCH FIRST 2 ROWS ONLY) ORDER BY SALARY ASC FETCH FIRST 2 ROWS ONLY

[@thulasireddy4514]

Sir oracle full course unda

[@SivaAcademy]

Not yet bro

[@kumarbrajesh5051]

How to count Number of column in a table without using metadata in Sql

[@SivaAcademy]

Will answer in upcoming video in this series, please stay tuned.

[@ashokkumar-hm5on]

select salary rank() over(order by salary desc),DENSE_RANK()OVER(order by salary desc)from employees not working

[@feyie]

Hi Siva, can u help me? I need to get the sum of the total value of each element that's grouped per pay date. And I need to display it in my report as one row . Here's the sample data (4 rows): Column1: Pay date 15-Jan-2022 30-Jan-2022 15-Jan-2022 30-Jan-2022 Column2: element Pay allowance Pay allowance2 Pay allowance Pay allowance2 Column3: total 500 300 500 300 I used a case statement but it doesn't work. SELECT a.personid, TRUNC(TO_DATE(a.pay_date, 'DD-MON-YYYY')) pay_date CASE WHEN a.element LIKE 'Pay Allowance%' OR 'Pay Allowance2' THEN 'Pay Allowance Benefit' ELSE NULL END as Pay_Allowance_Benefit , SUM(a.total) FROM (SELECT tbl4.personid, TRUNC(TO_DATE(tbl3.val_date, 'DD-MON-YYYY')) pay_date ,tbl2.name element ,tbl1.value total FROM tbl1 ,tbl2 ,tbl3 ,Tbl4 Where clause) a WHERE a.personid = :p_id GROUP BY a.element , a.person_id , TRUNC(TO_DATE(a.pay_date, 'DD-MON-YYYY'))

[@diptikokate7348]

Thank you so much sir