SQL Interview Questions and Answers | Intellipaat

[@Intellipaat]

Guys everyday we upload in depth tutorial on your requested topic/technology so kindly SUBSCRIBE to our channel👉( bit.ly/Intellipaat ) & also share with your connections on social media to help them grow in their career.🙂

[@colletteayamba5875]

Please I need help to answer my interview very so I can get a job do you offer training?

[@АлёнаБондаренко-б9в]

@@colletteayamba5875 ц,шьъ

[@muskansoni1265]

Hey guys, you're doing great job by helping us to understand these difficult courses easily. Please upload an advanced SQL tutorial video as well. It would be much helpful. :)

[@shivenkhajuria2488]

@intellipaat - Could you also please share a video on oracle reports and pl/sql?

[@annaanna8927]

Great job, thank you very much. What I especially appreciate is showing how we can run all these statements in sql

[@Intellipaat]

You're very welcome!

[@vinayrh316]

This method is simpler for copying data from 1 table to another table. -----copy the parent table schema rather than creating a new table with the column list-- select top 0 * into new_table from old_table ----then load the data---- Insert into new_table select * from Old_table

[@rehanbaig71]

Great trainer, effective methodology, deserve 7 star rating. It will be very nice if links of tables used in this video provided for practice along the video.

[@Intellipaat]

Thanks for the feedback. :) But sorry links are not available.:(

[@AmitRaj-yy6nn]

A great review and suggestion

[@Intellipaat]

Guys, which technology you want to learn from Intellipaat? Comment down below and let us know so we can create in depth video tutorials for you.:)

[@rameshganta1071]

Power BI

[@Intellipaat]

Hi Ramesh, here's the video link for Power BI: kzbin.info/www/bejne/f2SseKBvbLZpZtU

[@anshurai1631]

Informatica PIM 360

[@meetstudios3273]

C++ and data structure and algorithms

[@amitshippie]

For copying structure and data we can also write select * into newtable from oldtable. If we want only structure then can write select * into newtable from oldtable where 1=2

[@Rajjain_]

great video! @14.22 Actually, Postgres SQL allows the use of where clause even if you use group by, in that case WHERE clause will be used before grouping is done and HAVING clause if used check condition for group means applied after grouping. If anyone can confirm it. Great video btw thank you.

[@Intellipaat]

Welcome. Keep learning with Intellipaat😊

[@PrashanthG]

Perfect tone for teaching. It reaches in single shot.

[@Intellipaat]

@prashanth-g Do like, share & subscribe to our channel to get updates on upcoming videos.

[@kaustubhsharma4490]

Last question - copy from one table to another. Was creating a new table necessary ? Cant we just do this - Select * into employee_duplicate from employee

[@jatinpant6992]

you are right, we don't have to create a table for that. it can be directly done.

[@dheerajk6716]

We can use Select * into tbl2 from tbl1 But in case we need the exact table schema which has constraints and keys associated , then select * into doesn't do that.. hence table schema is created first and then insert into script is used.. This is useful when we are working on table having huge records for faster data retrieval

[@subhasrikhanrah8716]

My goodness how simple and how detailed teaching in a short time ..thanks

[@Intellipaat]

Glad it was helpful! @Subhasri Khanrah Do like, share & subscribe to our channel to get updates on upcoming videos

[@deepdive429]

Hello! Your content is useful. I'm not an expert but I learned somewhere to copy structure of one table into another in 17th question you created same structure for a new table instead of this you can direct create structure with the query given below: Create table table_name like target_table;

[@Intellipaat]

Great it was helpful. Keep learning with Intellipaat. :)

[@Harvi_srh]

Ur video helped me a lot . I attended interview today they asked 3 questions which are there in ua video so I answered them easily

[@Intellipaat]

That's so great Shravani. Good luck & Keep learning with Intellipaat. :)

[@jaiswalakash100]

what are the 3 question asked in interview?

[@shivarajhalageri2513]

Shravani how were you able to get the interview call from where did you apply

[@pranavkulkarni4165]

In Question 15 i.e. about UNION and UNION ALL operator the output you showed is wrong I think so. The extra orange fish is present rather than Blue Fish. Kindly Clarify. Addition to that want to say that your videos are super helpful and we are getting all the knowledge from fundamental to expert things. Regards, Pranav K

[@pranavkulkarni4165]

Users are spending time to write an comments but if you people didn't respond to that then whats the use of KZbin channel and comment box.

[@chetanpatil9892]

with u i can understand completly sir other on intelipatt moving very speed

[@Intellipaat]

@Chetan Patil Hope it is helpful Do like, share & subscribe to our channel to get updates on upcoming videos.

[@swatishambhavi3649]

You've thoroughly explained each and every answer, thank you so much, sir.

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@swatishambhavi3649]

@@Intellipaat for sure :)

[@naveen95959]

Sir the Tutorial was very helpful to me from the beginning SQL tutorial for beginners to this SQL Interview questions tutorial. All the topics were clearly explained by you. And I thank you for your dedicated contribution towards teaching & learning sector of the technology. I'll be thankful to you forever and I hope you'll be coming up with more advanced SQL interview question tutorials & other advanced technologies. Thank you again Sir.

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat. :)

[@surajkumarwinner]

I really learnt a lot .. great skill , great mentor. the way are u teaching it's really tremendous.

[@Intellipaat]

Thank You @Suraj kumar

[@DibyenduMitraRoy]

The 4th question (finding the second-highest salary) can also be answered in the following way "SELECT * FROM `employee` ORDER BY e_salary DESC limit 1,1"

[@Intellipaat]

cool.

[@rahulaggarwal5057]

Is this in SQL Server or MySQL?

[@TadiRammohanreddybablu]

Oracle: SELECT * FROM (select e_name,e_salary,dense_rank() over (order by e_salary desc) ranking from employee) WHERE ranking=2

[@arunkumarkumar3833]

Your query seems like mysql query

[@bajrangibhaijaan9260]

Create table Employee_Dup as Select * from Employee; Using this single statement we can create as well as copy record.

[@suriyaprakashthatchinamoorthy]

"Select * into Employee_Dup from Employee" also used

[@butoyighyslain171]

extremly well done..I feared it would be borin but it was perfect!!

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat😊

[@ravisaxena95]

Appreciated work done in this video so would like thanks for this kind of technical video.

[@Intellipaat]

Glad you liked it. @Ravi Saxena For personal support, you can reach out to our course advisors on IND: [phone] US: 1-800-216-8930 (Toll-Free).

[@praveenbarkali9582]

Hi sir...... When u r typing a query in SQL database it's not clear to viewer.... U r explanation is very good sir...

[@galaxyjoseph4612]

Thank You so much!!!!!!! it is very helpful.

[@Intellipaat]

@Galaxy Joseph Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.

[@akhilhonnuru8321]

Happy to see u here bharani

[@rajatgupta-qr8hz]

Better than edureka. Good to explain with an example.

[@aryanshinde1822]

Select * from employee as e1. where 3-1=(select count (distinct)(salary) from employee as e2 where e2.salary>=e1.salary,

[@Intellipaat]

If you wish to get Personal support Kindly call our course advisors on IND: [phone] US: 1-800-216-8930 (Toll-Free).

[@mahiii7723]

Good lecture and great explanation keep it going bro..........

[@Intellipaat]

Thanks a lot

[@ravindranaths581]

Very basic question... Good for students

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat😊

[@sukanyabhosale8042]

for DELETE command delete row from column and is roll back but in TRUNCATE command it can not be roll back

[@thesujata_m]

1 correction for aggregate functions: we can use where clause in aggregate queries too, for aggregate group by is mandatory

[@harivaradan2989]

Yes u r crt

[@akashvarma6822]

ya ur genius

[@balamuralikrishnab1625]

What is the query for this Write a program to find list of duplicate mobileno in a list Assume there is a list populated with mobileno. Now in this list there can be some numbers repeated. Output of the program should have List of mobileno which is repeated at least once

[@raghuputapawalu1851]

The video was very helpful to us and the way of making vidoe and teaching level simple brilliant

[@Intellipaat]

Thank you @raghu putapawalu Keep Learning: )

[@praveenreddy9020]

Appreciatable work sir.....thank you

[@karma3949]

How to get result in text column as underlined and coloured font for any DML update query? For example Please submit your delivery Papers before Jan 1 - Jan 1 should underlined with yellow fonts.

[@Intellipaat]

If you wish to get Personal support Kindly call our course advisors on IND: [phone] US: 1-800-216-8930 (Toll-Free).

[@Achandra7]

I used to watch great learning videos because of you sir not for any certificates.

[@Intellipaat]

Glad you like them!

[@TheVishal1994]

Superb Content.

[@Intellipaat]

Glad you think so! Keep watching! Thank you!

[@taniyasharma8924]

Excellent💯

[@Intellipaat]

Thank you! Cheers!

[@konduruvenkatraju7876]

Hello sir, Your doing a fantastic job continue like this , whatever u r explaining your videos very clearly and little bit and good concept✌❤

[@Intellipaat]

Thank you

[@subramaniang5265]

Such an excellent trainer, provided with nice presentation. Thanks a lot!!!

[@Intellipaat]

Glad you liked it!

[@kpereiraestrada]

Excellent service

[@JITENDRAPAL21]

liked his communication skill

[@Intellipaat]

thank you.

[@bharathm5322]

GOOD EXPLANATION

[@Intellipaat]

Thank you for watching. :)

[@santoshmunj3352]

Cheers bro, explained really very well. However, for advanced learners need more in depth concepts for example- how to remove duplicates from a table?. Thanks in advance for such videos.

[@Intellipaat]

Sure Santosh, the videos will be uploaded soon, keep learning with Intellipaat. :)

[@AmitSharma-qx6ry]

Thank you so much !!! This video helped me got one !

[@Intellipaat]

You're welcome! @Amit Sharma Keep learning with us.

[@ashitavermani4508]

very well explained

[@Intellipaat]

Thankyou @Ashita Vermani Keep learning with us:- )

[@arunavanka1240]

hello sir very good explanation but can I know the IDE u used plz

[@japhetkiplagat8452]

powerful this is a powerfull at the same time this is the career am persuing bro can i can get soome feed back to know much about this?

[@akhiljidigum6097]

Thankyou for sharing lot of knowledge,this is very helpful to me.

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@seemakiran2977]

It mdhe job kartat ka

[@cutybebo1438]

Thank you so much sir ....... it's very benefit for us.....

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@shubhsharmaaa]

Hi cuty

[@akshatabali2325]

Hey can you please tell me the difference between inner join and intersect opration because both of these method returns same output

[@Intellipaat]

Sure. In the next session.

[@akshatabali2325]

@@Intellipaat thank you 😇

[@deepaksingh9318]

very helpful for quick preparation in short time ...

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@venkatasubbareddy6179]

Very good explanation. Thank you so much 🙏

[@Intellipaat]

Welcome. stay tuned to Intellipaat😊

[@jagadishmithun]

It is a very good and please update graphical user interface lab sir plzzz

[@Intellipaat]

👍 Cool. :)

[@piyushrai6293]

Thanks for the good tuition

[@Intellipaat]

You are welcome @Piyush Rai Do like, share & subscribe to our channel to get updates on upcoming videos.

[@amanahmed6057]

but now he is in great learning platform

[@SumitKumar-qc3wd]

Thanks for this video, Its really helpful.

[@P5toraskar1986]

Superb video

[@Intellipaat]

Thank you so much 😀 @Parag Toraskar Do like, share & subscribe to our channel to get updates on upcoming videos.

[@hennychestnut5479]

thanks man really clear direction, and good english speaking as well!!!!!!!!!!

[@Intellipaat]

Welcome. :)

[@shahidkarim2260]

Thnks u soo much which can help me in my learning

[@ubongmbaba2319]

Thanks for the video. Please can you upload data analysis with R

[@Intellipaat]

Sure. Noted.:)

[@d.choudhary2705]

Pls upload advance level sql interview questions and answers videos.

[@Intellipaat]

Hi Dinesh, in this video we have covered basics and advanced both the questions. Please watch the complete video. :)

[@d.choudhary2705]

@@Intellipaat I watched then replied. I mean , pls make videos with little complex examples. So those will helpful for working professional too.

[@Intellipaat]

Alright. Will upload another video with more advanced questions. Stay tuned to Intellipaat channel.:)

[@d.choudhary2705]

@@Intellipaat I like your videos and work. Doing good job.

[@Intellipaat]

@@d.choudhary2705 Thanks a lot. Keep learning with Intellipaat.:)

[@AbhiGamer683]

thanks a lot for this short and crispy useful tutorial, what is the difference between UNION and INNER JOIN ? please

[@Intellipaat]

JOIN in SQL is used to combine data from many tables based on a matched condition between them. UNION in SQL is used to combine the result-set of two or more SELECT statements.

[@srinu3737]

VERY BASIC QUS

[@lnentertainment5509]

Could you please upload videos on SSIS and SSRS?

[@Intellipaat]

Sure. Noted. Will upload soon. 🙂

[@sambhajighare8193]

Nice tutorial. Thanks 👍

[@rrl1919]

Really nice exaplanation--sir please make video on ETL validation

[@Intellipaat]

Sure we will.

[@akshaysilgari2097]

Great video bro

[@Intellipaat]

Glad you enjoyed!

[@chinnuteju9059]

Thank you so much sir☺

[@Intellipaat]

Most welcome.

[@UKJ28]

Hello Sir, please increase the font size in all videos, I have to skip such good videos due to font size. Thanks

[@desifoodiegirl07]

Can you please make a video on SQL query which were frequently asked in interview for experienced ..

[@Intellipaat]

Sure . Noted. Will upload soon. :)

[@BilalKhan-sx9eu]

Explained Well.

[@Intellipaat]

Thank you @Bilal Khan

[@ramyareddy4224]

THANKS SIR IT IS VERY HELPFUL FOR US

[@VishnuVardhan-br4yp]

I like your way of teaching

[@Intellipaat]

Thanks Vishnu.:)

[@nifrasthahir2596]

Excellent! And Excellent!

[@Intellipaat]

Glad you like it! Stay tuned to Intellipaat😊

[@abdulravoof6444]

Very informative

[@Intellipaat]

Glad it was helpful!

[@shivaniverma2055]

Thank u Sir I understood your session 👍

[@Intellipaat]

Glad it was helpful. Keep learning with Intellipaat. :)

[@arunkumarr2302]

Very worthy 👍❤️

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat😊

[@marvelvsdc6370]

In depth JavaScript tutorial .. please

[@Intellipaat]

Hi, we will be uploading this video very soon. Stay tuned!

[@TekTuition]

Q17 answer is Select * Into NewTableName From OldTableName

[@Intellipaat]

Okay.:)

[@anandkumar-xu3yq]

To learn sql. We should have any coding or programming skills?

[@nikhilreddy5996]

not needed this is purely independent

[@anandkumar-xu3yq]

@@nikhilreddy5996 thanks buddy

[@Intellipaat]

There is no need of programming skills to learn SQL. :)

[@mjmak82]

Liked... Very much presentful

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat. :)

[@miteshjain56]

Best explanation nice sir

[@Intellipaat]

Thanks. Stay tuned to Intellipaat to keep learning. :)

[@ajin_thelosttraveller]

Please add video for PKI and Cryptography interview questions 🙏

[@DB-sf1hy]

Where is a stored procedure saved? How can you view it after it is created?

[@razkenable]

Could you please send the link for your data set

[@Intellipaat]

Thank you so much for appreciating the content. Your feedback motivates us to make more such content. Unfortunately, we don't share the source code or presentation deck with anyone. Although, if you wish to learn from Industry Experts and IIT Faculty, do fill out this form and we will reach out to you. Have a great day! . Google Form: forms.gle/XWy7MtQPrHkgq7Pt7

[@dishanx]

Duplicate table and insert, Select * into employee_duplicate from employee;

[@Intellipaat]

cool.

[@yuvrajsaini732]

Absolutely I was about to write this in comment section

[@getasewkasahun76]

Hey buddy could U UPLOAD SSRS interieview questions.

[@punk77777]

nice video, it really helps me.

[@Intellipaat]

Glad to hear that!

[@samruddhivaidyaloke1028]

please upload pl/sql tutorial

[@shubairabbas5480]

You are awesome

[@Intellipaat]

Thankyou. :)

[@justinakwetey5566]

Please is there a DDL script available to creat the DB so i can practice ?

[@VishnuVardhan-br4yp]

Do some advanced

[@Intellipaat]

Noted. Stay tuned!

[@AshwiniJagtap-cg7fv]

Sir it's good combination of theory and practical but the text at bottom due to that not able to see the tables at bottom

[@Intellipaat]

Hi, if it is the subtitle, then click on "cc" (bottom, right side) once again so that it will be hidden, and then you can view the video content.

[@sukhibhava7010]

Is this enough for experienced candidates also?

[@Intellipaat]

Yes more than enough.

[@mohammedjasim2797]

Hi can you help me pleas I need export query or select statement to excel sheet by sql code Pleas code not wizard And who can use for loop in stord prosedur ....thanks for help me ..

[@ramireddygopalreddy4316]

I want learn SSIS any new batches starting

[@Intellipaat]

Yes @ramireddy gopalreddy For personal support you can reach out to our course advisors on IND : [phone] US : 1-800-216-8930 (Toll Free).

[@thelastdragonbender5824]

nicely explained!

[@Intellipaat]

Glad you liked it

[@kolukuluriaditya2284]

Can you make a video on btech passed out in 2019; what to do

[@Intellipaat]

Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.

[@themachinelearningarchitect]

Awesome 😉

[@Intellipaat]

Glad you liked it. Keep learning with Intellipaat.:)

[@altamashkhan5009]

How to write a command for 3rd highest salary

[@nikhilreddy5996]

can you please make a video on interview questions for experienced people this one is good but i think we will face more complex questions from interviewer

[@Intellipaat]

Sure, will forward the topic to the respective team and will upload the video soon. Please subscribe to Intellipaat channel & press the bell icon so that you don't miss that video from us.