Hello sir, as u said on 1:58 that last rank is equal to the total number of employees and that is the keycheck that whether rank has been calculated rite or not...but if the last two 2 salaries would have been '1248' only ,the last 2 ranks would be 13-13 only. so in a way we cannot calculate number of rows with rank. correct me if i am wrong
Sir, good explanation but where do you need to use Rank and where do you use Dense Rank? How do a developer know which one to use? If the rank is same which record is picked first in the order by series? can it be randomly picked?
Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand. It will be very thankful, if you make video on this. Thanks in advance cheers.
Sir i have just started learning PL/SQL myself and also given some interviews but i need to learn more. So can you please guide me how to learn. If you suggest to join your classes, I will.
If you are already working, then I won't suggest for classes, because its easy for working professional to read through and prepare, the interview question series will cover 70 percent of learning, and you need to concentrate on practical scenario. Many questions already posted, however this needs practice
very helpful information hatsoff sir
Hello sir, as u said on 1:58 that last rank is equal to the total number of employees and that is the keycheck that whether rank has been calculated rite or not...but if the last two 2 salaries would have been '1248' only ,the last 2 ranks would be 13-13 only. so in a way we cannot calculate number of rows with rank.
correct me if i am wrong
Yes you are correct 👍
Start
0:14 - Rank and Denserank
2:28 - Now we will see how to write a Query
Good explanation sir
These are the best vedios in this year
Thanks for your comments bro 🙏🙏🙏
Awesome explanation. Thank you sir
You are welcome
Hi siva, your video is very helpful. but there no sample code attached in this blog . if sample code is attached it will be very useful
Wow! I didn’t know anything about those functions. Very good explanation. Thank you.
Welcome....Thank you so much :-)
What is industry use cases of rank and dense rank
@@vishalbhardwaj969 Capital Markets
Great explanation..keep it up sir
Thanks and welcome
Good explanation sir
Thanks
Welcome Harisha
Thanks shiva but can u tell me where we can used rank function
many places, whereever we need to rank bank on values, for ex, rank for mark, or amount spend in a month based on category etc,,
Thanks well explained
Thank you
good video
Thank you
Sir, good explanation but where do you need to use Rank and where do you use Dense Rank? How do a developer know which one to use? If the rank is same which record is picked first in the order by series? can it be randomly picked?
Thank you so much ....!! Can we have video on difference between 10g, 11g and 12c
Where can we use RANK and DENSE_RANK?
Thank you sir❤️
Welcome bro
Can you please make a video on regular expression and type of regular expression with small example in easy way to get it understand.
It will be very thankful, if you make video on this.
Thanks in advance cheers.
sure, please stay tuned
Must be share advantages or real time example or use of rank function
Siva, pls explain about oracle architecture. It's been asked in am interview
@Bharathi, yeah it's a must know topic for plsql developers, I will add into my todo list, and post soon.
Can you plz explain difference between last_value and last functions in OLAP
Sure, kindly stay tuned
Please give an example of Rank, Dense_Rank and all other Analytical functions using Partition.
Sure, will cover the other analytical functions in upcoming videos, Please stay tuned
Sir i have just started learning PL/SQL myself and also given some interviews but i need to learn more. So can you please guide me how to learn. If you suggest to join your classes, I will.
If you are already working, then I won't suggest for classes, because its easy for working professional to read through and prepare, the interview question series will cover 70 percent of learning, and you need to concentrate on practical scenario. Many questions already posted, however this needs practice
Hi Siva,
Hope your doing well.
In what scenario we need to use rank and dense rank
depends on whether you want continuous ranking on not.
diffrance between union ,union all, minus ,intersect
thank you
You're welcome
Kindly do Unix classes
Sure please stay tuned
@@SivaAcademy start brother asap, as many lost their job in covid pendemic.
Super
Thank you :-)
Regards,
Siva
@@SivaAcademy bro..pls share the link if you already provided performance tuning videos..if not pls prepare
@nn jj, Ya bro, I am preparing the content for performance videos, once done I will post. Thanks for your comments, stay tuned.
Thanks,
Siva
@@SivaAcademy thanks bro your explanation is awesome.
@nn jj, Welcome :-), Happy to hear, thanks for your comment.
Regards,
Siva
Please let me know it r y talking any class shiva