The 25 SQL Questions You MUST Know for Data Analyst Interviews

Поделиться
HTML-код
  • Опубликовано: 22 дек 2024

Комментарии • 245

  • @KSRDatavizon
    @KSRDatavizon  2 года назад +7

    Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our RUclips channel 👉Please ping on WhatsApp wa.me/9916961234

  • @DataExplorer21
    @DataExplorer21 5 месяцев назад +15

    I had an interview today and these questions are valid till date. So many questions in these were asked in round 1.

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад +2

      i am glad its helpfull to you, hope you Got the Job. all the best for your future.

    • @aayuushorts
      @aayuushorts 29 дней назад

      for which type of job you give interview?

    • @DataExplorer21
      @DataExplorer21 27 дней назад

      @@aayuushorts It was for a BI role.

    • @aayuushorts
      @aayuushorts 27 дней назад

      @@DataExplorer21 in which stream you have done your graduation and masters?

  • @AshishTiwari-ug2lg
    @AshishTiwari-ug2lg 7 месяцев назад +5

    The Most Underrated Teacher or Guru in IT in India Mr. Santosh Sir
    If you learn from him , you are never going to fail for interview.

  • @AnkitKaushal-d2g
    @AnkitKaushal-d2g Год назад +1

    Thank you sir for consolidating all the important questions in a single concise video.

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      You are most welcome, Please subscribe our channel, it motivates a lot

  • @healyourstress7658
    @healyourstress7658 2 года назад +4

    My favourite educator .. ❤ sir I wish you get more success

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Hope you are liking it !! keep watching

  • @BhanuPrakash-mf7br
    @BhanuPrakash-mf7br 2 года назад +14

    The way of explanation is awesome, Thanks a lot for the valuable information.
    Sir we are expecting more videos from you in the future with Real time Scenario aswell.

  • @arunn7255
    @arunn7255 2 года назад +32

    Really u r videos are very helpful bro...if we watch just u r projects videos on power BI, top 25 interview question and EY real time interview...these videos are enough for cracking the interview....thnks alot for u r wor...

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +2

      Thank you so much for your msg, we are trying to get placed as much as students we can. we are very happy if it helps to even one single student.

    • @ReferKaroEarnKaroo
      @ReferKaroEarnKaroo Год назад

      Hello Arun can u help me for interview

  • @devd5355
    @devd5355 2 года назад +2

    Wow best SQL video thanks

  • @vamshiabhilash
    @vamshiabhilash 2 года назад +6

    Respect for you sir your really kind enough to even reply to the comments n provide links to tutorials when asked expecting more visualization interview videos from your team..

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +1

      Thanks for your words.. Definitely we will upload more videos

  • @HemaBhargavi-xx8gs
    @HemaBhargavi-xx8gs Год назад +1

    The way you are explaining the topic is Awesome.

  • @princysingh1398
    @princysingh1398 2 года назад +2

    very true collection of sql for interview

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      thank you so much, please subscribe our channel for regular updates.

  • @raginishrivastav4264
    @raginishrivastav4264 Год назад +2

    Great 🙌 nice video it's very helpful thanks

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      You are most welcome, Please subscribe our channel, it motivates a lot

  • @MahammedKareemulla
    @MahammedKareemulla Год назад +1

    For me in interview so many interview Question asked from this list. like windows function,joins, rank,dense_rank,Union,unionall etc. be prepare guys before go to interview. Thanks to KSR to provide like this veios in social platform. i did subscribe and like👋🤌expecting more vedios from u r channel.

    • @KSRDatavizon
      @KSRDatavizon  9 месяцев назад

      Thank you for your support! Your subscription and likes mean a lot, and I'll work on more videos on these topics.

    • @aayuushorts
      @aayuushorts 29 дней назад

      for which type of job you give interview?

    • @MahammedKareemulla
      @MahammedKareemulla 28 дней назад

      @@aayuushorts For powerBI Developer/Data Analyst

    • @aayuushorts
      @aayuushorts 25 дней назад

      @@MahammedKareemulla are you freshet in data analyst after graduation or you have prior work experience

  • @karanmalkhede6689
    @karanmalkhede6689 2 года назад +1

    Todays most important video for me thanks plz bring more video like this
    And plz make video on top questions ans of powerbi

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +1

      Thank you for liking our videos, sure will make more like these

  • @ThePlaceUncovered
    @ThePlaceUncovered 12 дней назад

    I am grateful is limiting my appretiation. Thanks

    • @KSRDatavizon
      @KSRDatavizon  6 дней назад

      You are very welcome, Please subscribe our channel for regular updates.

  • @vigneshwariguru2098
    @vigneshwariguru2098 Год назад

    Its amazing explaination...
    God bless u to get more success in life..Thankyou so much

  • @aziserak4743
    @aziserak4743 Месяц назад

    Thank you so much for your amazing teaching ❤️

  • @ravireddy270
    @ravireddy270 2 года назад +1

    Tqs for ur effort..It really helpful for Beginners who are facing the interviews.

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Thank you so much, please subscribe our channel.

  • @muralimohan3350
    @muralimohan3350 8 месяцев назад

    Thanks a lot for your nice explanation.

    • @KSRDatavizon
      @KSRDatavizon  8 месяцев назад

      Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot

  • @sovanpattnaik07
    @sovanpattnaik07 5 месяцев назад

    Sir ! your videos are really helpful and very crisp and easy to understand. Thank you so much for creating!

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      You're welcome! I'm glad my videos are proving helpful. I strive to make my content as clear and concise as possible.
      If you have any other questions or requests, please don't hesitate to ask.

  • @pranavjogladevikar4738
    @pranavjogladevikar4738 2 года назад

    In upcoming days i will facing interview for BI developer. And from few days i will try to finding videos for interview preparation and suddenly yesterday i got your 1st video about BI questions really bro all questions are related and I'm feeling understandable after watching it tqq bro 🙏

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      All the best Pranav, please do watch other Power Bi interview videos here
      ruclips.net/video/hqEoRn5ciXQ/видео.html
      ruclips.net/video/AUV6stwRNQM/видео.html
      ruclips.net/video/1Hgh3BMQ_TU/видео.html
      ruclips.net/video/WM7RSMzKrZ8/видео.html

  • @CctnsHelpdesk
    @CctnsHelpdesk 9 месяцев назад

    But we can use aggregated column in where by using nested query/sub query/cte

    • @KSRDatavizon
      @KSRDatavizon  9 месяцев назад

      You're absolutely right! While aggregate functions can't be directly used in the WHERE clause of most relational databases, you can achieve the desired filtering effect by using a subquery (also called a nested query) or a Common Table Expression (CTE).

    • @CctnsHelpdesk
      @CctnsHelpdesk 9 месяцев назад

      thank you..this what i learned from santosh sir@@KSRDatavizon ... (KSR Student)

  • @Maahi812
    @Maahi812 Год назад +1

    Hi Sir way of explaining is soooo good, awesome.
    It would be better if u show us the queries by writing instead of saying words

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Noted, will do those kind of video. please subscribe our channel for more details.

  • @monicaakannan9461
    @monicaakannan9461 7 месяцев назад

    This is very helpful and very clearly explained. Thanks!

    • @KSRDatavizon
      @KSRDatavizon  7 месяцев назад

      I'm glad you found it helpful! Please subscribe our channel for regular updates and it motivates us a lot.

  • @manjupreetham
    @manjupreetham 2 года назад

    The things which you are explained is best to get job in interview thank you so much sir

  • @ajinkyashinde1778
    @ajinkyashinde1778 2 года назад

    Very Well Explained... !!! thank you for the detail and clean answers

  • @srinukummari9135
    @srinukummari9135 2 года назад

    It's help ful. But give queries as well. Thanks.

  • @sureshavullapalli2357
    @sureshavullapalli2357 Год назад +1

    Thanks for sharing interview questions. Nice explanation. Can you, Please share a video on SQL and PL SQL coding..... Sir.

  • @venkatasivaraobhimanaduni5137
    @venkatasivaraobhimanaduni5137 8 месяцев назад +1

    Great explanation

    • @KSRDatavizon
      @KSRDatavizon  8 месяцев назад

      Thank you for your feedback!

  • @TheVishalrockstar
    @TheVishalrockstar 2 года назад +3

    sir in some interviews they ask to perform in sql and powerbi with one small task eg-write the syntax to find the highest salary from employee table, write syntax whose name starts with A so plz make some practical based questions too. thanks in advance

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +1

      Yes we will upload videos on sql practical questions asap

    • @chinchusabu6583
      @chinchusabu6583 2 года назад +3

      U can use finding first letter Select * from table name where column name like 'A%';

    • @nikhildhiwar2355
      @nikhildhiwar2355 Год назад

      SELECT * FROM employee ORDER BY salary DESC ;

  • @Curic-Ivan
    @Curic-Ivan Год назад

    Excellent work! Thank you for sharing your knowledge!

    • @KSRDatavizon
      @KSRDatavizon  9 месяцев назад

      Your appreciation means a lot! I'm grateful for your support.

  • @MaDmAxLoCaL
    @MaDmAxLoCaL 2 года назад +1

    Video is very informative, Please do more videos.
    Only concern is, it would be better if u show us the queries by typing instead of saying words .
    Thank you!!

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +1

      Sure Sandeep, will improve it in next videos.

  • @ojusyummyreceipes7198
    @ojusyummyreceipes7198 2 года назад +2

    Very nice and useful information 👍

  • @rafiqalam8418
    @rafiqalam8418 5 месяцев назад

    Excellent Sir! Appreciating your hard efforts.❤

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      Thanks a ton, Please subscribe our channel, its motivates us a lot.

  • @Ali-ds5iy
    @Ali-ds5iy 2 года назад

    The way of explanation is awesome sit...Kudos!

  • @baby_Thenmadhi
    @baby_Thenmadhi 2 месяца назад

    wow thank you such clear questions and answer.

    • @KSRDatavizon
      @KSRDatavizon  2 месяца назад

      You're welcome! I'm glad I could provide a helpful response. Please let me know if you have any other questions. Please subscribe our cahannel for regular updates

  • @pranalialaspure1833
    @pranalialaspure1833 17 дней назад

    Really very helpful information

  • @SonuSonu-uh2er
    @SonuSonu-uh2er 2 года назад

    Loved your explanation sir. Thank you for this video

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      You are most welcome, please do share and subscribe our channel.
      here is the link for more SQL videos - ruclips.net/video/VZG2woFjI_4/видео.html

  • @stevel.2759
    @stevel.2759 Год назад +1

    Always check the stored procedures and triggers. For SQL it must follow SDLC with the user's requirements that were communicated to management. No matter what flavor ov Unix box. Sun, Solaris etc. Guys with main frame and mid range experience were easiest to train instead of PC dudes.

  • @sathyanarayanan4227
    @sathyanarayanan4227 6 месяцев назад

    DDLs can be rolled back in some recent versions of SQL SERVER

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад +1

      I'd be glad to provide a comprehensive response to the prompt "DDLs can be rolled back in some recent versions of SQL SERVER":
      Yes, Data Definition Language (DDL) statements can indeed be rolled back in recent versions of SQL Server. This feature is primarily available in SQL Server 2012 and later versions.
      Here's a breakdown of how DDL rollback works:
      Transaction Scope: DDL statements must be executed within a transaction scope for rollback to be possible. This is achieved using the BEGIN TRANSACTION and COMMIT TRANSACTION statements.
      Rollback Trigger: SQL Server automatically creates a rollback trigger for DDL statements executed within transactions. This trigger captures the necessary information to undo the changes in case of a rollback.
      Rollback Mechanism: When a rollback occurs (e.g., due to an error or an explicit ROLLBACK TRANSACTION statement), SQL Server uses the captured information from the rollback trigger to reverse the DDL changes.
      Key Points to Remember:
      Transaction Scope: DDL statements must be within a transaction for rollback.
      Rollback Trigger: SQL Server automatically creates a rollback trigger.
      Rollback Mechanism: SQL Server uses the captured information to reverse changes.
      Example:
      SQL
      BEGIN TRANSACTION;
      -- Create a new table
      CREATE TABLE MyNewTable (
      ID INT PRIMARY KEY,
      Name VARCHAR(50)
      );
      -- If an error occurs or you decide to rollback:
      ROLLBACK TRANSACTION;
      Use code with caution.
      Additional Considerations:
      DDL Rollback Limitations: While DDL rollback is generally reliable, there might be certain scenarios where it might not be fully effective, such as when the rollback trigger fails or if underlying system changes are involved.
      Performance Impact: Using DDL rollback frequently might have a slight performance impact, as it involves additional overhead for the rollback trigger and the rollback process.
      Best Practices: Consider using DDL rollback judiciously, especially for critical DDL changes. It's often a good practice to test DDL changes in a non-production environment before applying them to production.
      By understanding DDL rollback in SQL Server, you can leverage this feature to enhance data management and recovery capabilities within your database applications.

  • @easwerprakhyath1878
    @easwerprakhyath1878 2 года назад +1

    very useful and very effective

  • @supratikpaul6403
    @supratikpaul6403 2 года назад

    Please keep uploading this type of sql and power bi videos more thanks a lot sir

  • @techdular88
    @techdular88 Год назад +1

    Thanks for this sir.

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      You are welcome, Please subscribe our channel it motivates us

  • @VidyaVinayakamurthy
    @VidyaVinayakamurthy 6 месяцев назад +1

    Very nice video for the beginners...

  • @harimca3444
    @harimca3444 5 месяцев назад

    Really great explanation. Thankyou so much

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      You're welcome! I'm glad I could help. If you have any other questions, feel free to ask. Please subscribe our channel for regular updates.

  • @icici244
    @icici244 2 года назад

    Thank you so much bro . Finally I am able to solve all the ans from your vedio. Till now i ha e doubt that what will be the topics for power Bi interview on SQL . NOW I am confident enough that yes i can clear SQL round very easily 👍👍🙏🙏

  • @hellochandi1
    @hellochandi1 Год назад +1

    Ossam explain 🎉

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Thank you so much, Please subscribe our channel.

  • @snehmishra5492
    @snehmishra5492 Год назад

    Thanks Sir, Your videos are really helpful 👍

    • @KSRDatavizon
      @KSRDatavizon  9 месяцев назад

      Thank you so much for the kind words, it means a lot to me.

  • @meghab2910
    @meghab2910 2 года назад +1

    Very well explained 👍 please share answers for SQL coding questions

  • @angryff5768
    @angryff5768 2 года назад

    Good explanation sir thank you...i noted everything

  • @informationadda758
    @informationadda758 Год назад

    The way u explained it ossum dude

  • @MaheshSVB
    @MaheshSVB 2 года назад

    VERY NICE EXPLANATION AND VERY USE FULL VIDEO

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Thanks a lot Mahesh, keep watch other videos of SQL topics. ruclips.net/video/eNwy1GZNIi8/видео.html

  • @Ran12024
    @Ran12024 2 года назад +1

    Superb explanation 👏

  • @aziserak4743
    @aziserak4743 2 года назад

    KSR is one of the best 👌 ❤ thank you ,you're explanation is amazing 👏

  • @VenkateshRamesh-qk7ny
    @VenkateshRamesh-qk7ny 5 месяцев назад

    THANK YOU SO MUCH FOR THE VIDEO.

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      Thank you so much , Please subscribe our channel for regular updtes, its motivates us

  • @aadarshchoudhary9648
    @aadarshchoudhary9648 2 месяца назад

    Very helpful sir thank you so much

    • @KSRDatavizon
      @KSRDatavizon  2 месяца назад

      Most welcome , please subscribe our channel 🙏🏻

  • @rinkupradhan5085
    @rinkupradhan5085 2 года назад

    Thank You brother!! Really very helpful🙏🙏🙏🙏👏👏

  • @sujeetmishra6892
    @sujeetmishra6892 Год назад

    We'll explained. Thanks man!

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Any time! Please subscribe our channel for regular updates

  • @sudheer2682
    @sudheer2682 Год назад +1

    Excellent!!! You are amazing. If you can make a video together with Tableau... that would be great!!!

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Very soon! Please subscribe our channel, it motivates a lot

  • @muralimohan3350
    @muralimohan3350 8 месяцев назад

    Nice explanation.

    • @KSRDatavizon
      @KSRDatavizon  8 месяцев назад

      Glad you liked it Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot

  • @roddam4391
    @roddam4391 2 года назад

    Very clearly explained. Worth to watch each n every video of urs 👌👌. Thanks a lot for giving us such good knowledge on subject

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Great.. thanks.. keep watching !!!

  • @lakshmajijakka
    @lakshmajijakka Год назад +1

    Thank you!

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      you are welcome, please subscribe our channel for regular updates.

  • @sandipansarkar9211
    @sandipansarkar9211 Год назад

    finished watching

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Thank you, Please subscribe our channel for regular updates , all the best

  • @midunsathiyamoorthy593
    @midunsathiyamoorthy593 9 месяцев назад

    Thank you,

    • @KSRDatavizon
      @KSRDatavizon  9 месяцев назад

      You are welcome , Please subscribe our channel for regular updates and it motivates us a lot

  • @chandrasekhar1883
    @chandrasekhar1883 2 года назад

    Awesome and clear.👏👏🤝

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Thank you 👍 Please do share in your network and subscribe
      Other SQL interview questions video - ruclips.net/video/29jJy4tAOPE/видео.html

  • @hncreations8176
    @hncreations8176 Год назад

    Thanks for the questions with answers❤

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Thank you so much, Please subscribe our channel for regular updates

  • @kalyaninilugonda4920
    @kalyaninilugonda4920 2 года назад

    Thankqq sooo much sir for this video and also plzz provide the solve the coding videos sir

  • @reddysekharsingadi4623
    @reddysekharsingadi4623 2 года назад +1

    Good job sir

  • @sravaniT-ur6ns
    @sravaniT-ur6ns 8 месяцев назад

    Hi sir
    Could you please provide answers for coding questions.....

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      sure, will plan to make more sessions, Thank You so much, Please subscribe our channel for regular updates, its motivates us a lot

  • @kiranid5782
    @kiranid5782 10 месяцев назад +1

    Please make a video practically how to write real time sql queries for interview

    • @KSRDatavizon
      @KSRDatavizon  10 месяцев назад

      Sure we will make it soon

  • @Omi12987
    @Omi12987 Год назад

    Outstanding

  • @heetshah1881
    @heetshah1881 Год назад +1

    Hello can you share the coding video questions?

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      sure will plan shortly , please subscribe our channel for regular updates

  • @sunilkatkar2915
    @sunilkatkar2915 2 года назад

    very usefull video

  • @shaiksk907
    @shaiksk907 Год назад

    Hi Sir, as i understand once commit after transaction we can't rollback either Truncate or Delete or drop.

    • @KSRDatavizon
      @KSRDatavizon  9 месяцев назад

      That's correct! Once a transaction is committed, you can't rollback changes made by Truncate, Delete or Drop operations.

  • @angadisuhail4174
    @angadisuhail4174 2 года назад

    This kind of interview questions will be helpful for many candidates and the efforts and content u r sharing is Awesome. Waiting for real time projects to upload in ur channel.. thanks a lot ❤️

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Very soon suhail, thank you for the feedback, please do share in your network. Please watch our End to End project here - ruclips.net/video/ahQrhyKmxGI/видео.html

  • @dattatrayarathi1014
    @dattatrayarathi1014 7 месяцев назад

    Thqnk you so much for sharing a video.
    Its help me a lot to crack the interview.
    Easy to understand with the explanation 🙏

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      Thank you, Please subscribe our channel for regular updates,

  • @krishnamurthy79
    @krishnamurthy79 2 года назад

    Very Nice Sir ...

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Thank you so much sir , please subscribe our channel

  • @NiceThought143
    @NiceThought143 Год назад +1

    Sir please answer de
    Mai. 12th pass hu
    Science maths kiya hu
    Kya mai data analysis kar sakta hu.
    Uske kaun kaun se software use hote hai woh bhi video mention Karo please 🙏🙏🙏🙏

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Hi sir, We need a degree to get more opportunities , with a graduation most of the companies won't hire us, you can start learning Data science and start a degree in distance, if possible take Statistics as a specialization. all the best sir.

  • @jk-sg6xb
    @jk-sg6xb 7 месяцев назад

    If u r changing the screen. That will be more helpful for better understanding. ..

    • @jk-sg6xb
      @jk-sg6xb 7 месяцев назад

      Whenever u r explaining explain with example.

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      sure, Thank you for your suggestion, Please subscribe our channel for regular updates,

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      sure, Thank you for your suggestion, Please subscribe our channel for regular updates,

  • @rahulgautam511
    @rahulgautam511 2 года назад

    Great Video Sir

  • @endalekinfe3391
    @endalekinfe3391 8 месяцев назад

    Thanks a lot

    • @KSRDatavizon
      @KSRDatavizon  8 месяцев назад

      Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot

  • @guilty_rasmus
    @guilty_rasmus 2 года назад

    This video is a gold mine. Thanks you Sir.

  • @sujeetmishra6892
    @sujeetmishra6892 Год назад

    Could you please make video on SSIS tutorials and interview questions for beginners to advanced level please. Once you get chance

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      Sure team, we will plan to make videos on MSBI topics too..

  • @shovabaral2797
    @shovabaral2797 3 месяца назад

    I’m looking for help . I need interview questions and answers for database developer position❤

    • @KSRDatavizon
      @KSRDatavizon  3 месяца назад

      will try to make some more session on this,

  • @vivekgoyal3545
    @vivekgoyal3545 2 года назад +1

    Any SQL classes sir? I want to learn from scratch any tutorial do u have please inform.

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      yes, please approach our team, for more details

  • @Sathvik_Gajjela
    @Sathvik_Gajjela 2 года назад

    Appreciated

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Thank you mam, please subscribe our channel, it motivates us.

  • @awakenedsouls3206
    @awakenedsouls3206 Год назад

    In the first question of sql coding , the 3rd maximum salary person , can we use large ( salary , 3) , to find the 3rd largest salary and then write an outer query to fetch the employee name from this table with the third largest salary ? Would it also be correct ?

    • @ashutoshrai2717
      @ashutoshrai2717 Год назад

      Where is this question in this video

    • @KSRDatavizon
      @KSRDatavizon  2 месяца назад

      yes you can write. .. large function will work in few databases. We strongly recommending to write generic sql code, which works in all database

  • @ጥቤTube2024
    @ጥቤTube2024 2 года назад

    Thank you amazing contant

  • @mohanr4372
    @mohanr4372 Год назад +1

    👌

    • @KSRDatavizon
      @KSRDatavizon  Год назад

      thank you, please subscribe our channel,

  • @awakenedsouls3206
    @awakenedsouls3206 Год назад

    Also , in the second question , can we use row number () over ( partition by id order by id ) , so that any id that duplicates will have the row no as 2 and the rest will have one , so we can select the records where row number =2 ?

    • @maheshtiwari2297
      @maheshtiwari2297 Год назад

      You can simple do
      With cte as (
      Select *, row_number() over(partition by Id order by Id) as rnk
      From temp)
      Delete from cte
      Where rnk 1

    • @KSRDatavizon
      @KSRDatavizon  2 месяца назад

      Yes we can do that as well

  • @nomulavijaya7500
    @nomulavijaya7500 2 года назад +1

    Hello sir….Are these still good for Power BI Analyst Role or do you have any updated Questions Videos on SQL and POWER BI.

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +1

      these question will help for data analyst role interviews and Will upload more soon

  • @narayanjena4259
    @narayanjena4259 2 года назад

    Please upload as soon as possible the interview question on SQL Coding. Also add some more questions in coding questions.

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +2

      Sure thanks for suggestions. We will upload more

  • @vijayachandrareddysingared3271
    @vijayachandrareddysingared3271 2 года назад

    Hai sir I have a doubt that IN SSMS SQL WE CAN ROLL BACK SOME OF DDL STATEMENTS ALSO.

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Hi, 👉Please ping us on WhatsApp wa.me/919916961234 to have a word with our trainer

  • @yezdani-k9u
    @yezdani-k9u 6 месяцев назад

    GREAT

    • @KSRDatavizon
      @KSRDatavizon  6 месяцев назад

      Thank you so much for your kind words!

  • @dvenki9492
    @dvenki9492 2 года назад

    Thanks for this Video, can you assist Same for Azure Data Factory, which helps me a lot.

    • @KSRDatavizon
      @KSRDatavizon  2 года назад

      Thanks for suggestions. We will upload asap

  • @Random-l8j
    @Random-l8j Год назад +2

    Hi All.
    I have prepared for the interview by watching this..
    I got selected and working already..same qns i got in interview.most helpful content

    • @KSRDatavizon
      @KSRDatavizon  Год назад +1

      All the best, Please subscribe our channel for regular updates, its motivate us a lot

  • @sakshinaik05
    @sakshinaik05 2 года назад +1

    Sir is it necessary to give a lengthy ans in an interview or I can give crisp and clear to the point ans

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +2

      Elaborate answers will give you good impression to panelist

  • @perfectionist6624
    @perfectionist6624 2 года назад

    Hi sir.. waiting for most asked SQL queries interview QnA...

    • @KSRDatavizon
      @KSRDatavizon  2 года назад +1

      Ma'am already we have a video on this:
      ruclips.net/video/VAOpMH_iXMA/видео.html

  • @lakshmimanasa7218
    @lakshmimanasa7218 2 года назад

    dml commands are not rollback,but delete can be roolback .

  • @EmDiAverageGamer
    @EmDiAverageGamer 2 года назад +1

    Hi, Sir, I want to ask one thing. If I am able to answer till intermediate will I able to get a beginner-level job?