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.🙂
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. :)
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
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.
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
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.
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
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
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"
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.
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
THnk yoy so much for the tutorial. I want to practice what you teach in this video. So, my question is, ¿ Is there any chance we could access the database you used for doing those queries? Thank you so much!
Thanks for the question! Unfortunately, I can't share the database used in this video. But I encourage you to practice on your own database, or you can find many public datasets online to test your skills!
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;
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.
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
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.
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
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.
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.
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.🙂
Please I need help to answer my interview very so I can get a job do you offer training?
@@colletteayamba5875 ц,шьъ
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. :)
@intellipaat - Could you also please share a video on oracle reports and pl/sql?
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.:)
Power BI
Hi Ramesh, here's the video link for Power BI: ruclips.net/video/I3IGm97Q60s/видео.html
Informatica PIM 360
C++ and data structure and algorithms
Great job, thank you very much. What I especially appreciate is showing how we can run all these statements in sql
You're very welcome!
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
Perfect tone for teaching. It reaches in single shot.
@prashanth-g Do like, share & subscribe to our channel to get updates on upcoming videos.
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.
Thanks for the feedback. :) But sorry links are not available.:(
A great review and suggestion
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
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.
Welcome. Keep learning with Intellipaat😊
Thank You so much!!!!!!! it is very helpful.
@Galaxy Joseph Glad you liked it 😊 Do like, share & subscribe to our channel to get updates on upcoming videos.
with u i can understand completly sir other on intelipatt moving very speed
@Chetan Patil Hope it is helpful Do like, share & subscribe to our channel to get updates on upcoming videos.
My goodness how simple and how detailed teaching in a short time ..thanks
Glad it was helpful! @Subhasri Khanrah Do like, share & subscribe to our channel to get updates on upcoming videos
Excellent💯
Thank you! Cheers!
Appreciated work done in this video so would like thanks for this kind of technical video.
Glad you liked it. @Ravi Saxena
For personal support, you can reach out to our course advisors on IND: +91-7022374614 US: 1-800-216-8930 (Toll-Free).
I really learnt a lot .. great skill , great mentor. the way are u teaching it's really tremendous.
Thank You @Suraj kumar
Superb Content.
Glad you think so!
Keep watching!
Thank you!
extremly well done..I feared it would be borin but it was perfect!!
Glad you liked it. Keep learning with Intellipaat😊
Good lecture and great explanation keep it going bro..........
Thanks a lot
Appreciatable work sir.....thank you
The video was very helpful to us and the way of making vidoe and teaching level simple brilliant
Thank you @raghu putapawalu Keep Learning: )
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
That's so great Shravani. Good luck & Keep learning with Intellipaat. :)
what are the 3 question asked in interview?
Shravani how were you able to get the interview call from where did you apply
You've thoroughly explained each and every answer, thank you so much, sir.
Glad it was helpful. Keep learning with Intellipaat. :)
@@Intellipaat for sure :)
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
you are right, we don't have to create a table for that. it can be directly done.
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
Hello sir,
Your doing a fantastic job continue like this , whatever u r explaining your videos very clearly and little bit and good concept✌❤
Thank you
Such an excellent trainer, provided with nice presentation. Thanks a lot!!!
Glad you liked it!
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"
cool.
Is this in SQL Server or MySQL?
Oracle:
SELECT * FROM (select e_name,e_salary,dense_rank() over (order by e_salary desc) ranking from employee) WHERE ranking=2
Your query seems like mysql query
Create table Employee_Dup as Select * from Employee;
Using this single statement we can create as well as copy record.
"Select * into Employee_Dup from Employee" also used
Select * from employee as e1. where 3-1=(select count (distinct)(salary) from employee as e2 where e2.salary>=e1.salary,
If you wish to get Personal support Kindly call our course advisors on IND: +91-7022374614 US: 1-800-216-8930 (Toll-Free).
Thanks for the good tuition
You are welcome @Piyush Rai Do like, share & subscribe to our channel to get updates on upcoming videos.
but now he is in great learning platform
very well explained
Thankyou @Ashita Vermani Keep learning with us:- )
Happy to see u here bharani
Thank you so much !!! This video helped me got one !
You're welcome! @Amit Sharma Keep learning with us.
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.
Glad you liked it. Keep learning with Intellipaat. :)
Very good explanation. Thank you so much 🙏
Welcome. stay tuned to Intellipaat😊
Very basic question... Good for students
Glad it was helpful. Keep learning with Intellipaat😊
Excellent service
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
Users are spending time to write an comments but if you people didn't respond to that then whats the use of RUclips channel and comment box.
Thankyou for sharing lot of knowledge,this is very helpful to me.
Glad it was helpful. Keep learning with Intellipaat. :)
It mdhe job kartat ka
very helpful for quick preparation in short time ...
Glad it was helpful. Keep learning with Intellipaat. :)
THnk yoy so much for the tutorial.
I want to practice what you teach in this video.
So, my question is, ¿ Is there any chance we could access the database you used for doing those queries?
Thank you so much!
Thanks for the question! Unfortunately, I can't share the database used in this video. But I encourage you to practice on your own database, or you can find many public datasets online to test your skills!
GOOD EXPLANATION
Thank you for watching. :)
Nice tutorial. Thanks 👍
Excellent! And Excellent!
Glad you like it! Stay tuned to Intellipaat😊
Superb video
Thank you so much 😀 @Parag Toraskar Do like, share & subscribe to our channel to get updates on upcoming videos.
Thnks u soo much which can help me in my learning
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;
Great it was helpful. Keep learning with Intellipaat. :)
Very worthy 👍❤️
Glad you liked it. Keep learning with Intellipaat😊
Thank you so much sir☺
Most welcome.
Thanks for this video, Its really helpful.
Explained Well.
Thank you @Bilal Khan
Hi sir...... When u r typing a query in SQL database it's not clear to viewer.... U r explanation is very good sir...
Very informative
Glad it was helpful!
Better than edureka. Good to explain with an example.
Great video bro
Glad you enjoyed!
I like your way of teaching
Thanks Vishnu.:)
liked his communication skill
thank you.
THANKS SIR
IT IS VERY HELPFUL FOR US
for DELETE command delete row from column and is roll back but in TRUNCATE command it can not be roll back
Really nice exaplanation--sir please make video on ETL validation
Sure we will.
1 correction for aggregate functions: we can use where clause in aggregate queries too, for aggregate group by is mandatory
Yes u r crt
ya ur genius
I used to watch great learning videos because of you sir not for any certificates.
Glad you like them!
Best explanation
nice sir
Thanks. Stay tuned to Intellipaat to keep learning. :)
nice video, it really helps me.
Glad to hear that!
Thank you so much sir ....... it's very benefit for us.....
Glad it was helpful. Keep learning with Intellipaat. :)
Hi cuty
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.
If you wish to get Personal support Kindly call our course advisors on IND: +91-7022374614 US: 1-800-216-8930 (Toll-Free).
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
Awesome 😉
Glad you liked it. Keep learning with Intellipaat.:)
Pls upload advance level sql interview questions and answers videos.
Hi Dinesh, in this video we have covered basics and advanced both the questions. Please watch the complete video. :)
@@Intellipaat I watched then replied. I mean , pls make videos with little complex examples. So those will helpful for working professional too.
Alright. Will upload another video with more advanced questions. Stay tuned to Intellipaat channel.:)
@@Intellipaat I like your videos and work. Doing good job.
@@d.choudhary2705 Thanks a lot. Keep learning with Intellipaat.:)
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.
Sure Santosh, the videos will be uploaded soon, keep learning with Intellipaat. :)
thanks man really clear direction, and good english speaking as well!!!!!!!!!!
Welcome. :)
VERY BASIC QUS
It is a very good and please update graphical user interface lab sir plzzz
👍 Cool. :)
Hey can you please tell me the difference between inner join and intersect opration because both of these method returns same output
Sure. In the next session.
@@Intellipaat thank you 😇
You are awesome
Thankyou. :)
Liked... Very much presentful
Glad you liked it. Keep learning with Intellipaat. :)
Thanks for the video. Please can you upload data analysis with R
Sure. Noted.:)
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?
Thank u Sir
I understood your session 👍
Glad it was helpful. Keep learning with Intellipaat. :)
Could you please upload videos on SSIS and SSRS?
Sure. Noted. Will upload soon. 🙂
In depth JavaScript tutorial .. please
Hi, we will be uploading this video very soon. Stay tuned!
Can you please make a video on SQL query which were frequently asked in interview for experienced ..
Sure . Noted. Will upload soon. :)
Please add video for PKI and Cryptography interview questions 🙏
hello sir very good explanation but can I know the IDE u used plz
Hello Sir, please increase the font size in all videos, I have to skip such good videos due to font size. Thanks
Could you please send the link for your data set
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
nicely explained!
Glad you liked it
thanks a lot for this short and crispy useful tutorial, what is the difference between UNION and INNER JOIN ? please
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.
Where is a stored procedure saved? How can you view it after it is created?
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
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.
To learn sql. We should have any coding or programming skills?
not needed
this is purely independent
@@nikhilreddy5996 thanks buddy
There is no need of programming skills to learn SQL. :)
Q17 answer is Select * Into NewTableName From OldTableName
Okay.:)
Please is there a DDL script available to creat the DB so i can practice ?
Can you make a video on btech passed out in 2019; what to do
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.
Do some advanced
Noted. Stay tuned!
Hey buddy could U UPLOAD SSRS interieview questions.
Duplicate table and insert,
Select * into employee_duplicate from employee;
cool.
Absolutely I was about to write this in comment section
please upload pl/sql tutorial
I want learn SSIS any new batches starting
Yes @ramireddy gopalreddy For personal support you can reach out to our course advisors on IND : +91-7022374614 US : 1-800-216-8930 (Toll Free).
Is this enough for experienced candidates also?
Yes more than enough.
Would like to what is a recursive CTE and where it is used in SQL
Hi, we will cover in the next session. :)
Good video
#SMQJALDHT
Thank you for watching. :)