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

[@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..

[@shubhamsahu1352]

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

[@CodingGlitz]

Thanks bhai

[@lilyfullery4779]

Thanks for the video .

[@neerajmalviya31]

Nic lecture

[@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

[@poonamgharge6189]

Really helpful thank you sir.

[@HakikatStudios]

Good 👍

[@CodingGlitz]

Thanks, 🙂

[@smritisingha5152]

Really great video

[@CodingGlitz]

Thanks 🙂

[@advitkothari7302]

helpful!! accelarate my preparation

[@jagdish_soni3098]

Wow , your way off teaching 👏.

[@CodingGlitz]

Thank you! 😃

[@saurabhbhangale6584]

Thank You So Much sir_⭐⭐⭐⭐⭐

[@beingcheercool]

Thank you very much sir 😊

[@EUK379]

very nice content i like it

[@CodingGlitz]

Thank you very much

[@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.

[@shravanikeni6218]

Your teaching is awesome ❤

[@CodingGlitz]

🙂

[@Sneha-yn4zx]

I learnt so many things from you thank you so much

[@CodingGlitz]

Glad it helped ☺️

[@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 👍👍

[@jyotikothari499]

Good explanation

[@waheguru-gh7ps]

you are doing great job !

[@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

[@There_is_no_God_but__ALLAH]

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

[@AbdulMajid-b4f]

Really Helpful

[@madhueducation143]

Nice

[@AparajitaJena-cy3mp]

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

[@aryasunil9041]

This video was extremely helpful for my placements

[@CodingGlitz]

All d very best for future.😊

[@vasimuddinsheikh3766]

Have you got the job?

[@anamikapatel4418]

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

[@CodingGlitz]

In SQL server

[@MND44]

Helpfull content...thank you bro

[@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 😊

[@vaishnvimane369]

Please bring more such videos of sql queries

[@CodingGlitz]

Sure 😊

[@sagarsharma007]

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

[@CodingGlitz]

Thanks 😊

[@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

[@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

[@z900_Guy]

You are a saviour ♥️♥️

[@singhisking639]

best video ever bro. Thanks a lot for your effort

[@CodingGlitz]

Thanks bro.. Please do like and share😊

[@VishalAgnihotri-o2v]

thankyou so much sir

[@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

[@santhoshkumar8143]

Thanks brother for your Valuable information

[@patel_05_roma]

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

[@CodingGlitz]

Thanks 😊

[@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???

[@magantianusha5746]

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

[@CodingGlitz]

Great 👍

[@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)

[@ghanshyam014]

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

[@pushpahatetears]

You're awesome!!!

[@CodingGlitz]

Thanks 😊

[@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

[@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

[@RupeshKumar-tp7nw]

Maja aa gaya thx

[@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 .

[@TheKamakshya]

really good content thanks so much!

[@pandu1730]

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

[@CodingGlitz]

Thanks😃

[@saurabhsonawane9025]

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

[@inspired_enough_to_grow_up]

bro OS ke liye bhi banado

[@Kudapali_fans]

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

[@deepjyotiray2010]

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

[@CodingGlitz]

Thanks Bhai. 😊

[@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 .🙂

[@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

[@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.

[@kostavdg]

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

[@CodingGlitz]

Thanks ☺️

[@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.

[@gsuneel4679]

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

[@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

[@beingcheercool]

15:00

[@nehaprasad6665]

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

[@CodingGlitz]

😊😊

[@ghanshyam014]

All the best for your upcoming episodes 😊

[@CodingGlitz]

Thanks a lot🙏

[@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 🙂

[@beingrishi6450]

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

[@kongaratenikar2098]

nice explanation ;)

[@shanukatiyar2742]

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

[@CodingGlitz]

Glad to know that🙂

[@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.

[@cheerladinnemouli2864]

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

[@CodingGlitz]

All d best.

[@cheerladinnemouli2864]

@@CodingGlitz tq sir

[@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

[@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.

[@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.

[@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

[@travelkare]

Thanks!

[@HemantTukaram]

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

[@CodingGlitz]

Which db are you using??

[@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).

[@beingrishi6450]

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

[@tarakofficial2891]

For 24 th query if count is odd then is their any method to find

[@CodingGlitz]

For odd and even you can always use MOD

[@MuhammadUmairShaykh]

Gr8

[@pranishsonone7839]

table banate time date kese liye yr nahi jam raha

[@CodingGlitz]

Kaun sa database use kar rhe ho?? Yahan pe Oracle use hua h.

[@pranishsonone7839]

Ok bhai me mssql server kr raha hu

[@HARSHRAJ-gp6ve]

Q9) with cte as( select DATE(NOW()) AS day1 ),cte1 as( select YEAR(day1) as y1,(MONTH(day1)-1) as t FROM cte ),cte2 as( select cte1.*, CASE when LENGTH(t)=1 THEN '0' ELSE 'null' END AS intial FROM cte1 ) select LAST_DAY(CONCAT(y1,'-',CONCAT(intial,t),'-','01')) as date3 FROM cte2;

[@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.

[@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

[@nicksaha1021]

Sir 13th question ka ans. Apka alag hai kyu ki usme employee details mangi h jiski doj 2020 ho. Iske liye we can write :- Select * from employee Where date of join like '%2020' Select * from employee Where year(date of join) = '2020'

[@showbizstyle9572]

how can we practice? can you share dummy data

[@biswajitsingh7501]

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

[@sohelpathan7601]

Where to get tables for practicing all questions ..!

[@CodingGlitz]

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

[@I_am_smooth_as_butter]

Bhai code bhi daal dete insert karne ka..we don't have data to practice along with you

[@CodingGlitz]

Description me data hai

[@intradaytrend8422]

70/100

[@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....

[@vijendrabijalwan7936]

sir in questions ki pdf mil payegi

[@leoking2386]

Can you tell how can we do Q24 in MySQL?

[@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

[@SyedDanishHusain-n7j]

73/100

[@vikkynarepagul256]

Select * from employee order by salary DESC LIMIT 3

[@CodingGlitz]

In MySQL

[@shreyashkukde6678]

ye jo table hai jo queries ke liye use kiye hai vo kaha se milnege

[@CodingGlitz]

Sry laptop crash ho gaya tha so data. Nhn h mere paas aap dekh k table create kar do

[@CodingGlitz]

Checkout below doc for creating table and data used in this video: docs.google.com/document/d/1Xv9xCNTGZm4SuAlR5hmzOoraq_Jc2YIZ/edit?usp=sharing&ouid=108295025764141437347&rtpof=true&sd=true

[@Barishrima]

Very helpful, thank you🙏