RANK and DENCE_RANK in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar

Поділитися
Вставка
  • Опубліковано 5 вер 2024
  • RANK and DENCE_RANK in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
    ** For Online Training Registration: goo.gl/r6kJbB ► Call: +91-8179191999
    💡 Visit Our Website for Classroom Training:
    nareshit.in/or...
    💡 For Online Training:
    nareshit.com/o...
    #Oracle #Training #CourseVideos
    --------------------------
    💡 About NareshIT:
    "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
    --------------------------
    💡 Our Online Training Features:
    🎈 Training with Real-Time Experts
    🎈 Industry Specific Scenario’s
    🎈 Flexible Timings
    🎈 Soft Copy of Material
    🎈 Share Videos of each and every session.
    --------------------------
    💡 Please write back to us at
    📧 us.training@nareshit.com/ 📧 online@nareshit.com or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
    --------------------------
    💡 Check The Below Links
    ► For Course Reg: goo.gl/r6kJbB
    ► Subscribe to Our Channel: goo.gl/q9ozyG
    ► Circle us on G+: plus.google.co...
    ► Like us on Facebook: / nareshit
    ► Follow us on Twitter: / nareshitek
    ► Follow us on Linkedin: goo.gl/CRBZ5F
    ► Follow us on Instagram: goo.gl/3UXYK3

КОМЕНТАРІ • 52

  • @NareshIT
    @NareshIT  5 років тому +2

    Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

  • @adnanashraf1279
    @adnanashraf1279 5 років тому +9

    I saw your several VDOs, you teach in a very simple way. You are excellent teacher.... and I love your accent..

  • @sriharshavemuri
    @sriharshavemuri 6 років тому +4

    DENSE naming needs to be updated in the Video section. It's not DESCE it is DENSE. Very good video made concept very clear.

  • @user-um5hg3py7d
    @user-um5hg3py7d 2 місяці тому

    Thank you for saving me tons of time

  • @sahilaherkar888
    @sahilaherkar888 2 роки тому

    Sir you really made it look very simple.
    Thanks👍

  • @vijayrajjakhmola4615
    @vijayrajjakhmola4615 3 роки тому

    Thanks Sir, Very well explained, I understand this only through your video. Sir , one questions is, When to use Rank function, and when to use the dens_rank ? in our query data. Please reply sir. Thanks

  • @allofit-aboutall6269
    @allofit-aboutall6269 6 років тому +1

    very well explained sir.
    Thanks for sharing the knowledge.

  • @balajigold1877
    @balajigold1877 Рік тому

    Tq sir 👍👍🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

  • @hmarenna4009
    @hmarenna4009 4 роки тому

    Excellent explanation.... really you are greate sir....

  • @sumaunnam1522
    @sumaunnam1522 3 роки тому

    Excellent explanation, Thank so much sir.

  • @F_A_R_man
    @F_A_R_man 2 роки тому

    Thanks a lot, sir. Like your explanation.

  • @rajeshgoud1187
    @rajeshgoud1187 2 роки тому

    thanks you so much sir

  • @rhushishinde1392
    @rhushishinde1392 4 роки тому

    excellent . You explained dense rank and rank functions nicely ...I would like to see more and more videos like this in future..

  • @pavanmadamset
    @pavanmadamset 7 років тому

    Excellent Explanation Sir! Thank You Very Much, Vijay Kumar Sir!!! I am learning because of You Sir!!!

  • @bipinairee1917
    @bipinairee1917 3 роки тому

    If Dense_rank is already there then what is the need of rank and rank also skip the rank sequence if we have same data in a column. If dense_rank can do everything then can you suggest any example where rank is useful and dense_rank not

  • @BuntriGuyTech
    @BuntriGuyTech 7 років тому +1

    Thanks Naresh. Great tutorial on the rank subjects.

  • @kalyankumar34
    @kalyankumar34 2 роки тому

    Thanq soo much sirr...!!!!!

  • @shrikantmaurya4376
    @shrikantmaurya4376 4 роки тому

    Great Explanation Naresh!
    Thanks for sharing.

  • @indirapatil547
    @indirapatil547 3 роки тому

    Great explanation Thank you sir

  • @Truth_teller07
    @Truth_teller07 7 років тому

    Thank you so much sir ...i understand what is analytical functions because of your videos only... i really thank you sir

  • @ramyanaveenvlogs3428
    @ramyanaveenvlogs3428 7 років тому

    Thank you so much sir !! I understand such easily because of your simplified explanation !!

  • @rajkumarsaroj8337
    @rajkumarsaroj8337 Рік тому

    Super..Sir

  • @khelabapujari3528
    @khelabapujari3528 2 роки тому

    superb... teaching statergy

  • @Rooster-777
    @Rooster-777 11 місяців тому

    thanks BOSS

  • @vishwanathgr2532
    @vishwanathgr2532 2 роки тому

    Nice explanation 🙏

  • @SarojKumar-xy9ls
    @SarojKumar-xy9ls 3 роки тому

    thanks for this topic.....

  • @techlearn207
    @techlearn207 3 роки тому

    extremely awesome 👏👏👏👍,

  • @antonyjayaraj95
    @antonyjayaraj95 3 роки тому

    மிகவும் அருமையான தகவல். நன்றி

  • @rajeshnaidu9331
    @rajeshnaidu9331 4 роки тому

    Thanks for the helping people

  • @upremkumar2952
    @upremkumar2952 3 роки тому

    Excellent sir

  • @vineetravi3938
    @vineetravi3938 3 роки тому

    How can we create a new table and store these values into that table?

  • @KalyanS
    @KalyanS 3 роки тому

    Nice presentation

  • @ravikiran3831
    @ravikiran3831 4 роки тому

    Sir can you place a video on query performance tuning

  • @mtoracle
    @mtoracle 3 роки тому

    Thanks Sir

  • @chavannamdev1959
    @chavannamdev1959 5 років тому

    Awesome , thank you sir.

  • @g2soft108
    @g2soft108 4 роки тому

    Excellent...!

  • @dreamvallyhasan4807
    @dreamvallyhasan4807 5 років тому

    Excellent

  • @ankurtripathi5877
    @ankurtripathi5877 5 років тому

    Thank you!

  • @arunilango2343
    @arunilango2343 6 років тому

    nice explanation

  • @govindpalariya3173
    @govindpalariya3173 7 років тому

    Thanks man

  • @kanthkanth1
    @kanthkanth1 4 роки тому

    NICE

  • @PratikBhuyarPatil
    @PratikBhuyarPatil 6 років тому

    nice one

  • @abhishek5847
    @abhishek5847 4 роки тому

    I am using sql developer and want to get all records with RNK = 1
    But it is giving following error
    Invalid column name ‘RNK’
    Can someone help thanks

    • @eldxD
      @eldxD 3 роки тому

      14:32

  • @PratikBhuyarPatil
    @PratikBhuyarPatil 6 років тому

    dence_rank,dense_rank

  • @knandi73
    @knandi73 2 роки тому

    Please change the title of this video. "It's RANK and DENSE_RANK in SQL" NOT "RANK and DENCE_RANK in SQL".

  • @swati8201
    @swati8201 7 років тому +2

    But it is Dense not Dence

    • @ramyanaveenvlogs3428
      @ramyanaveenvlogs3428 7 років тому +1

      thats's ok he can't help if you heard so !! get the analytical content, this is not English class !!

    • @swati8201
      @swati8201 7 років тому

      I do understand but please read the headline. So, it is not my hearing problem. Hope it is clear

  • @sairamkrishna369begenuine
    @sairamkrishna369begenuine 5 років тому

    Thank you sir.