SQL Queries Interview Questions and answers

[@CodingGlitz]

LinkedIn: www.linkedin.com/in/biplabparida Try and attempt Multiple Choice Questions below and do comment if you like the MCQ. forms.gle/4NHaRjoqFbYrgqrg9 Check out Solutions: kzbin.info/www/bejne/qYeTpKqKo7yWaKs Checkout the below doc for creating the table used in this video: docs.google.com/document/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/edit?usp=sharing&ouid=108295025764141437347&rtpof=true&sd=true

[@webxplore4746]

which SQL editor you have used in this video ?

[@CodingGlitz]

SQL Developer

[@curious_bird]

Sir Please Send the link of data you have used in this video. I need to practice it.

[@CodingGlitz]

@@curious_bird checkout: docs.google.com/document/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/edit?usp=sharing&ouid=108295025764141437347&rtpof=true&sd=true

[@NitinKumar_up_se]

28:48 28:51

[@yogenderkushwaha5523]

Thanks for the video man. Got selected in one of the company just by seeing 2 videos of SQL interviews questions and queries from your channel. ❤️

[@CodingGlitz]

Congratulations 🎊😃

[@mahesh1724]

Hi sir.. I am also learning SQL .. which company u joined sir.. please guide me

[@born_ambitious]

I am searching for job in sql and linux..but didn't get a single call from any company

[@suvarna625]

Also mention which videos so that it would be helpful to lot more people

[@vinamra95]

Nice.... Badhia revision ho gya interview ke pehle

[@CodingGlitz]

All the best for interview.

[@kingdomtrainings]

For 12th question instead of using (Ltrim(Rtrim)) we can use directly Trim(columname) if we use two functions ltrim(rtrim) unnecessarily it will decrease the performance. Instead we can use only one function which will give the exact result. Trim(Columnname) this will remove the trailing spaces from both sides. Hope this helps👍

[@CodingGlitz]

Correct..

[@poonamgharge6189]

Really helpful thank you sir.

[@shubhamsahu1352]

Sir no one on this planet is teaching like u .u r explaining everything from the scratch ❤ thanks sir

[@CodingGlitz]

Thanks bhai

[@daradevijay98music]

I went through all your videos on sql and plsql, the conceptual knowledge I gained helped me clear my interview at Infosys. Thank you very much big brother, will keep following your content. I have already suggested your videos to many of my colleagues as well, the way you explain is very simple for understanding. 🥂

[@CodingGlitz]

Thanks bro 👍👍

[@AparajitaJena-cy3mp]

Your explanations are incredibly clear and insightful! Would you be open to tackling some LeetCode questions as well ?

[@beingcheercool]

Thank you very much sir 😊

[@There_is_no_God_but__ALLAH]

Thanks for sharing such quality of knowledge 🥇🥇🥇🥇🥇🥇🥇🥇🥇🥇

[@shravanikeni6218]

Your teaching is awesome ❤

[@CodingGlitz]

🙂

[@patel_05_roma]

The Way of teaching is excellent💯👍👏 good job keep it up

[@CodingGlitz]

Thanks 😊

[@kostavdg]

Quite a helpful video !! Awesome. A must Subscribed channel.✌👌

[@CodingGlitz]

Thanks ☺️

[@lilyfullery4779]

Thanks for the video .

[@Sneha-yn4zx]

I learnt so many things from you thank you so much

[@CodingGlitz]

Glad it helped ☺️

[@MND44]

Helpfull content...thank you bro

[@jagdish_soni3098]

Wow , your way off teaching 👏.

[@CodingGlitz]

Thank you! 😃

[@saurabhbhangale6584]

Thank You So Much sir_⭐⭐⭐⭐⭐

[@waheguru-gh7ps]

you are doing great job !

[@pandu1730]

It's useful information.nice way of explanation.thank you bro.

[@CodingGlitz]

Thanks😃

[@neerajmalviya31]

Nic lecture

[@santhoshkumar8143]

Thanks brother for your Valuable information

[@sagarsharma007]

"BOHOT SAHI" --- ye umeed nahi kar raha tha intro ke liye ... jabarbast video mere bhai

[@CodingGlitz]

Thanks 😊

[@raginishrivastav4264]

Great content.. 🙌 thanks for the video 👍

[@CodingGlitz]

Check description. Need to make slight changes in syntax as per MySQL.

[@raginishrivastav4264]

​@@CodingGlitzyes got it. Thank you 😊

[@smritisingha5152]

Really great video

[@CodingGlitz]

Thanks 🙂

[@EUK379]

very nice content i like it

[@CodingGlitz]

Thank you very much

[@AbdulMajid-b4f]

Really Helpful

[@advitkothari7302]

helpful!! accelarate my preparation

[@sanjeebamat4485]

It is really helpful and almost covered all query in sql also make video Store procedure,triger ,function thanks a lot ❤

[@CodingGlitz]

Thanks!! .. Please checkout the PL SQL Playlist for Stored Procedures, Triggers, functions, etc. kzbin.info/aero/PLKVxK2jv1oA-LwzbMlOFZS-CgbucH5OhQ

[@HakikatStudios]

Good 👍

[@CodingGlitz]

Thanks, 🙂

[@singhisking639]

best video ever bro. Thanks a lot for your effort

[@CodingGlitz]

Thanks bro.. Please do like and share😊

[@vivekkapil4571]

Awesome video and it would really helpful for SQL journy 🎉thanks wish your channel gets more user 😇

[@CodingGlitz]

Thanks for watching. Please watch SQL playlist as well 🙂

[@jyotikothari499]

Good explanation

[@ghanshyam014]

I almost done by practicing , Good Content collection and Good presentation 👍

[@aryasunil9041]

This video was extremely helpful for my placements

[@CodingGlitz]

All d very best for future.😊

[@vasimuddinsheikh3766]

Have you got the job?

[@shraddhadhakad1154]

Your way of explanation the concept is awesome. Btw i have a question - are you a Indori ? 😅😅

[@CodingGlitz]

Thanks . I am from Rourkela (Odisha).

[@TheKamakshya]

really good content thanks so much!

[@z900_Guy]

You are a saviour ♥️♥️

[@cheerladinnemouli2864]

Awesome it's really helpful for my placements 🙏🙏 tqqs a lot

[@CodingGlitz]

All d best.

[@cheerladinnemouli2864]

@@CodingGlitz tq sir

[@VishalAgnihotri-o2v]

thankyou so much sir

[@madhueducation143]

Nice

[@SkAlhtar]

great content brother, it helps me a lot.............only I can say thank u.

[@CodingGlitz]

Great to hear it helped you.. All the best .🙂

[@saurabhsonawane9025]

Sirr joo..... Plz make vedio for top asked pl sql query 🙏🏻🙏🏻🙏🏻

[@nehaprasad6665]

Best dialogue so far in this video.. Aur yha aap reject ho jaoge 😂😂 Best video..easily explained all the concepts ♥️

[@CodingGlitz]

😊😊

[@pushpahatetears]

You're awesome!!!

[@CodingGlitz]

Thanks 😊

[@Barishrima]

Very helpful, thank you🙏

[@ghanshyam014]

All the best for your upcoming episodes 😊

[@CodingGlitz]

Thanks a lot🙏

[@MayankSinghParmar]

In the 3rd question the alternative for 'between clause' should not be 'greater than' and 'less than', it should be 'greater than or equal to' and 'less than or equal to'

[@CodingGlitz]

Thanks, Correct, by mistake I have mentioned greater than and less than.

[@shanukatiyar2742]

you cleared my many doubts and concepts thanks bro !!!

[@CodingGlitz]

Glad to know that🙂

[@travelkare]

Thanks!

[@ashokkumar-bs8ne]

Thankyou so much brother for such a wonderful content you have explained it in a very easy way❤

[@CodingGlitz]

Glad you liked it

[@beingrishi6450]

5:30 Can we update more than 1 condition in UPDATE clause?? Likewise UPDATE EMPLOYEE SET Salary = 64000 and ManagerId = 4 WHERE empID = 5???

[@kongaratenikar2098]

nice explanation ;)

[@MohdMuddasser]

Nice explanation... You gained a subscriber...keep up the good work..

[@CodingGlitz]

Thanks 😊

[@nakulanand2725]

Very well explained sir thanks😊

[@shrushtiingle1711]

Can you please guide us if we want learn how to write medium to complex level queries with respect to logic how to break a query,how to understand what is expected and steps required for it please

[@magantianusha5746]

i got 67 marks in this quiz.tq u so much for this it is very usefull to me.

[@CodingGlitz]

Great 👍

[@vaishnvimane369]

Please bring more such videos of sql queries

[@CodingGlitz]

Sure 😊

[@shubhamdeshmane6718]

Really helpful.. thank you so much sir..I want learn sql joins where I can learn all of that..

[@CodingGlitz]

Glat you liked this video. Checkout the below video for joins. kzbin.info/www/bejne/n6S0aaimYt-Ihrs Subquery:kzbin.info/www/bejne/e4LFmX6gd9KKbpo Also checkout other playlists which will be helpful for you.

[@Kudapali_fans]

30th solution SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET n-1;

[@santoshsonihzb]

select concat(ename||' ', job) from emp; -- this is also run for concate with blank sapace

[@CodingGlitz]

You can use multiple pipes to concat instead of using the concat keyword (unless not asked specifically to use Concat keyword)

[@akshaykharche6726]

Really great Bro! Nice pin-point explanation done in the video. Just one thing can we get database so we can practice this on our pc!.. Thanks in advance 👍

[@CodingGlitz]

Thanks.. Sure you can install Oracle database and I use SQL developer IDE which you can also install. kzbin.info/www/bejne/aIOvqnqXbsmlbqM

[@user-bv6il2nk4t]

top 50+30 pure dono vedio mean existing vedio jod ke one vedio bana do , ok and isme bas window function cte and thode complex sql add krwa do ok example bhai ankit bansal playlist

[@MuhammadUmairShaykh]

Gr8

[@beingrishi6450]

16:32 This is not working in MySQL as per query given in google drive form

[@snehayadavbpylbpbkdi1758]

One from non tech can easily understand your lectures. I'm starting your SQL beginner list but I'm not sure if your important SQL queries playlist is part of it or not. Can you please confirm?

[@CodingGlitz]

SQL Tutorial for Beginners || SQL Playlist Hindi: kzbin.info/aero/PLKVxK2jv1oA9Ow28rg__JaBWjJQtoPyu6

[@gsuneel4679]

Please teach in English as well, so that other language people also understands, thank you.

[@BipinSingh-cu5jj]

Sir between use krne pe given value output aata hai but ap between ke jagah greater than or less tha ka use and operator sath ise toh given value nhi ayega

[@CodingGlitz]

Correct

[@vaibhavsingh1538]

Solutions start from 4:48 minute

[@CodingGlitz]

If anyone wants to check solution to any particular question directly click on timestamp given in description.

[@Apna_tahlka_123]

Plj aaap excel k questions bhi lae aise hi practice k liye jldi se

[@ombhalerao21]

Sir can we use LIMIT=1 without using HAVING clause?

[@CodingGlitz]

Having aur limit ka use bilkul alag hai. So I assume we cannot use.

[@RupeshKumar-tp7nw]

Maja aa gaya thx

[@deepjyotiray2010]

bhai bhai ! Bhot late mila apka channel ! itne pyar se kon padhata hai yar

[@CodingGlitz]

Thanks Bhai. 😊

[@beingcheercool]

15:00

[@laxmanreddy2051]

please make videos in english next time tq for helping us

[@laxmanreddy2051]

Please provide any scenario based interview questions like ...sales data base. E com. Health care

[@srishtibhat6532]

Can you please tell suppose there is name like rohit and you need to display h and t how towrite a query forthat.Select SUBSTRING(3,5, 'ROHIT'); that will get characters at position 3,4,5 ut not only at 3,5.Can you help

[@CodingGlitz]

Please checkout this video and let me know if you still have any doubt. kzbin.info/www/bejne/Y4CQXn6Ir9SVl9U You can use 2 substrings and then concatenate.

[@inspired_enough_to_grow_up]

bro OS ke liye bhi banado

[@nitinkumar-xw1vg]

Bhai aap interview bhi lete ho kya.for SQl. Kch latest quesy answers please share kr do. Mera interview hai wipro me

[@CodingGlitz]

No

[@nitinkumar-xw1vg]

So, kindly share some important and latest questions which is asked in interview for SQl .

[@hemantkshirsagar]

I am using workbench. While i was practicing 3rd highest salary question im not getting row_num keyword? how to solve this.

[@CodingGlitz]

It will work in Oracle SQL which SQL are you using?? You can use limit in MySQL and top keyword in case of SQL Server

[@anamikapatel4418]

for 5th question we can also use select first_name + ' '+ last_name from Table_Name;

[@CodingGlitz]

In SQL server

[@bhuv16]

Thank you... Going to watch all your SQL Plsql videos...Thanks and keep making videos.

[@beingrishi6450]

9:33 Im getting 0 in each records in the output

[@RaviKr-h6n]

why datatype like varchar2, Number8 is not accepted by sql server...Its simply accepting INT or VARCHAR due to this I am not able to create the sample data....what is the solution ?

[@CodingGlitz]

www.w3schools.com/sql/sql_datatypes.asp

[@SyedDanishHusain-n7j]

73/100

[@intradaytrend8422]

70/100

[@venkatprasad5176]

this query is not working in MS SQL server management studio CREATE TABLE EMP AS(SELECT * FROM EMPLOYEE); getting eror like Msg 102, Level 15, State 1, Line 68 Incorrect syntax near '('. can you help me on this

[@CodingGlitz]

SQL server it will not work you need to use : Select * INTO emp FROM employee

[@venkatprasad5176]

@@CodingGlitz Thanks a lot it worked in MS SQL . One more help please . Write an SQL query to fetch the domain from an email address , For this to solve i did not fine INSTR built in function in MS SQL Server, can you guide me on this

[@CodingGlitz]

Instead of INSTR please use CHARINDEX

[@venkatprasad5176]

@@CodingGlitz yes i need to convert varchar to char data type it seems

[@lilyfullery4779]

many of the functions are there which are not working like instr and mod function can u please tell me why its happening.

[@CodingGlitz]

I think you are using MySQL or any other database. Just you need to search for its alternative in the database you are working on. If you are still facing problem let me know we will find the root cause and solution.

[@nakulanand2725]

Sir, main mod ka use kr rha hun toh error show ho rha h, mod is not recognize buit in function?

[@CodingGlitz]

SQL server use kar rahe ho to column % 2 use kar sakte ho.

[@HemantTukaram]

Tried que 23 as its but im not getting output. e1.salary in on clause

[@CodingGlitz]

Which db are you using??

[@vikkynarepagul256]

Select * from employee order by salary DESC LIMIT 3

[@CodingGlitz]

In MySQL

[@AbhishekSharma-vm7tr]

script from drive not running i pgadmin giving error

[@CodingGlitz]

Script is for Oracle SQL. For other database types you need to modify it with proper syntax

[@AbhishekSharma-vm7tr]

@@CodingGlitz its clear now thanks Do you have imp for excel?

[@CookNitesh]

can you plz provide the pdf of answers and questions in this video???......it will be very helpfull for me....

[@CodingGlitz]

Hey Nitesh, Sorry actually my laptop got crashed and all the materials which I had prepared are lost. I will definitely share if able to recover. Also there is delay in uploading further videos because of that.

[@CookNitesh]

@@CodingGlitz ok fine.... but let me tell u ,your videos are quite helpful for me....especially the interview questions videos.....thnx....

[@showbizstyle9572]

how can we practice? can you share dummy data

[@vijendrabijalwan7936]

sir question 23 may apne 2 table ki join kiya hai ya only employee table hi liya hai

[@CodingGlitz]

kzbin.info/www/bejne/h2rFeoJ4mdhjotE Ye wala video dekho detail me explain Kiya gaya h

[@leoking2386]

Can you tell how can we do Q24 in MySQL?

[@biswajitsingh7501]

can we have this tables..so that we can pratice on it..

[@ashutoshchauhan2492]

How can we delete duplicate records if we don't have any primary key?

[@CodingGlitz]

You need to get the min(rowid) in the same query and delete it.

[@sohelpathan7601]

Where to get tables for practicing all questions ..!

[@CodingGlitz]

docs.google.com/document/u/0/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/mobilebasic

[@ashwinikhodake7719]

Nice explanation : )

[@CodingGlitz]

Thanks

[@CodingGlitz]

Thanks ☺️

[@vijendrabijalwan7936]

sir in questions ki pdf mil payegi