How to copy a Table in SQL (with & without data) | SQL Tutorial for Beginners in Hindi

[@mainlykanchan8740]

Sql queries ko Hindi me solve krnw wala ye single channel h . Bht help milti h concept smjhne me . 👍 Thanks

[@xeonftw1408]

Thanks alot it was easy to create copy with data🔥

[@CodingGlitz]

Glad it helped

[@subhadarshisethy1680]

lucid explanatiom in hindi👍...pls do continue and add some advance sql question from stratascratch,hackerrank

[@shubhamjadhav3981]

This question asked me today. Thanks for the video

[@EducationHub112]

Best channel for SQL learning in hindi

[@CodingGlitz]

Thanks 🙏

[@rishtekhojocom]

great sir , it i very very simple way

[@CodingGlitz]

Glad it helped 🙂

[@prashantp9029]

Keep going brother

[@CodingGlitz]

Thanks for the constant support 😊

[@Untold_Incredible]

Boss content to accha hai hi, magar apki aawaz bhi bahut pleasant hai.

[@CodingGlitz]

Thanks 😊😊

[@rohtkadam1529]

Thanks very informative

[@abhishekrawat8305]

these queries are not working in SQL server can you please write same queries for sql server

[@CodingGlitz]

popsql.com/learn-sql/sql-server/how-to-duplicate-a-table-in-sql-server

[@BharathKumar-tu8yb]

This query not working in Microsoft sql server

[@CodingGlitz]

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

[@karanmalkhede6689]

great sir

[@CodingGlitz]

Thanks 🙂

[@karanmalkhede6689]

How to change table name in microsift sql server??

[@CodingGlitz]

In SQL Server you can use Select * INTO your_new_table_name from old_table

[@rajendraroyals1591]

super 👍

[@CodingGlitz]

Thank you 👍

[@MehdiRazaToronto]

Very Nice

[@CodingGlitz]

Thanks

[@yashmania_]

What if we write a query as CREATE TABLE EMPLOY3 AS select EMP_ID, DOB, ADDRESS from EMP; (DON'T WRITE FALSE CONDITION) ?

[@CodingGlitz]

Already explained in video.

[@CodingGlitz]

Whatever is selected in the select part of the query that will only be created.

[@yashmania_]

@@CodingGlitz that means writing false statement in above asked case isn't mandatory?

[@CodingGlitz]

No it is not mandatory. It is used to make sure table is created and data is not copied

[@mainlykanchan8740]

Thanks

[@harisubramanian7022]

nice bro

[@CodingGlitz]

Thanks 😊

[@pranithaalluri-i1n]

ERROR ARAHA

[@CodingGlitz]

This query is valid for Oracle db. Which db are you using??