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. :)
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
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.
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.
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"
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
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.
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.
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
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
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 ..
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.
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.
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
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.
Sir. je... Mere pass Dell ka laptop h... Jisme pata nahi kaya kharabi h.... Sir jo laptop hai .... Use open karne par bar bar open hota hai display pe dikhata h.. windows installating... Do not turn off PC Uske baad bar bar restart hote rehta hai.... Open hota hi nahi h..... Pata .nahi... Sir kripya bataye ki usme kaya kharabi. H.....
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?
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!
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: ua-cam.com/video/I3IGm97Q60s/v-deo.html
Informatica PIM 360
C++ and data structure and algorithms
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
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.
Thanks for the feedback. :) But sorry links are not available.:(
A great review and suggestion
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 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😊
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
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
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
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
You've thoroughly explained each and every answer, thank you so much, sir.
Glad it was helpful. Keep learning with Intellipaat. :)
@@Intellipaat for sure :)
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.
extremly well done..I feared it would be borin but it was perfect!!
Glad you liked it. Keep learning with Intellipaat😊
I really learnt a lot .. great skill , great mentor. the way are u teaching it's really tremendous.
Thank You @Suraj kumar
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. :)
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).
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
for DELETE command delete row from column and is roll back but in TRUNCATE command it can not be roll back
Good lecture and great explanation keep it going bro..........
Thanks a lot
Better than edureka. Good to explain with an example.
Appreciatable work sir.....thank you
Excellent💯
Thank you! Cheers!
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. :)
Happy to see u here bharani
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
Superb Content.
Glad you think so!
Keep watching!
Thank you!
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).
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 😇
The video was very helpful to us and the way of making vidoe and teaching level simple brilliant
Thank you @raghu putapawalu Keep Learning: )
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 UA-cam channel and comment box.
Very basic question... Good for students
Glad it was helpful. Keep learning with Intellipaat😊
Such an excellent trainer, provided with nice presentation. Thanks a lot!!!
Glad you liked it!
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
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
Excellent service
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).
GOOD EXPLANATION
Thank you for watching. :)
very helpful for quick preparation in short time ...
Glad it was helpful. Keep learning with Intellipaat. :)
Very good explanation. Thank you so much 🙏
Welcome. stay tuned to Intellipaat😊
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 ..
Hi sir...... When u r typing a query in SQL database it's not clear to viewer.... U r explanation is very good sir...
Thanks for this video, Its really helpful.
Thank you so much !!! This video helped me got one !
You're welcome! @Amit Sharma Keep learning with us.
Thank you so much sir☺
Most welcome.
Very worthy 👍❤️
Glad you liked it. Keep learning with Intellipaat😊
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
Excellent! And Excellent!
Glad you like it! Stay tuned to Intellipaat😊
Nice tutorial. Thanks 👍
very well explained
Thankyou @Ashita Vermani Keep learning with us:- )
Thnks u soo much which can help me in my learning
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
Superb video
Thank you so much 😀 @Parag Toraskar Do like, share & subscribe to our channel to get updates on upcoming videos.
Please is there a DDL script available to creat the DB so i can practice ?
Great video bro
Glad you enjoyed!
I used to watch great learning videos because of you sir not for any certificates.
Glad you like them!
Thank you so much sir ....... it's very benefit for us.....
Glad it was helpful. Keep learning with Intellipaat. :)
Hi cuty
I like your way of teaching
Thanks Vishnu.:)
liked his communication skill
thank you.
Explained Well.
Thank you @Bilal Khan
THANKS SIR
IT IS VERY HELPFUL FOR US
Thanks for the video. Please can you upload data analysis with R
Sure. Noted.:)
thanks man really clear direction, and good english speaking as well!!!!!!!!!!
Welcome. :)
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.:)
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. :)
Very informative
Glad it was helpful!
Best explanation
nice sir
Thanks. Stay tuned to Intellipaat to keep learning. :)
It is a very good and please update graphical user interface lab sir plzzz
👍 Cool. :)
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. :)
Really nice exaplanation--sir please make video on ETL validation
Sure we will.
VERY BASIC QUS
hello sir very good explanation but can I know the IDE u used plz
Duplicate table and insert,
Select * into employee_duplicate from employee;
cool.
Absolutely I was about to write this in comment section
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?
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?
Liked... Very much presentful
Glad you liked it. Keep learning with Intellipaat. :)
You are awesome
Thankyou. :)
Thank u Sir
I understood your session 👍
Glad it was helpful. Keep learning with Intellipaat. :)
Q17 answer is Select * Into NewTableName From OldTableName
Okay.:)
Awesome 😉
Glad you liked it. Keep learning with Intellipaat.:)
nice video, it really helps me.
Glad to hear that!
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
Can you please make a video on SQL query which were frequently asked in interview for experienced ..
Sure . Noted. Will upload soon. :)
In depth JavaScript tutorial .. please
Hi, we will be uploading this video very soon. Stay tuned!
stuff function is not working in my sql workbench. How can I resolve it.
Could you please upload videos on SSIS and SSRS?
Sure. Noted. Will upload soon. 🙂
Please add video for PKI and Cryptography interview questions 🙏
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. :)
Hey buddy could U UPLOAD SSRS interieview questions.
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.
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.
nicely explained!
Glad you liked it
Hello Sir, please increase the font size in all videos, I have to skip such good videos due to font size. Thanks
Do some advanced
Noted. Stay tuned!
How to write a command for 3rd highest salary
Sir. je...
Mere pass Dell ka laptop h...
Jisme pata nahi kaya kharabi h....
Sir jo laptop hai .... Use open karne par bar bar open hota hai display pe dikhata h.. windows installating... Do not turn off PC
Uske baad bar bar restart hote rehta hai.... Open hota hi nahi h.....
Pata .nahi...
Sir kripya bataye ki usme kaya kharabi. H.....
Hi, your windows is corrupt. Download a genuine copy and it will be fine. :)