VIEWS IN SQL || CREATE VIEW FROM SINGLE TABLE / MULTIPLE TABLES || DROP VIEW

CREATE VIEW FROM SINGLE TABLE
Syntax
CREATE VIEW VIEW_NAME AS
SELECT COL_NAME1,COL_NAME2 , . . . FROM TABLE_NAME
WHERE CONDITION
CREATE VIEW FROM MULTIPLE TABLES
Syntax
CREATE VIEW VIEW_NAME AS
SELECT COL_NAME1, COL_NAME2, . . . . FROM TABLE1, TABLE2, . . .
WHERE TABLE1.COL_NAME = TABLE2.COL_NAME AND CONDITION
DELETE VIEW
DROP VIEW VIEW_NAME
------------------------------------------------------------------------------------------
HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10
• HOW TO DOWNLOAD & INST...
DATABASE MANAGEMENT SYSTEM
• DATABASE MANAGEMENT SY...
PYTHON PROGRAMS
• PYTHON PROGRAMS
C PROGRAMMING
• 01 - VARIABLES & CONST...
CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS
• CORE JAVA TUTORIAL FOR...
HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS
• HTML TUTORIALS WITH IM...
LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS
• LEARN CSS IN 3 HOURS |...
JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT
• JAVA SCRIPT FOR BEGINN...
PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)
• Python in One Shot (తె...
PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)
• PYTHON - OOPS CONCEPTS...
PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU
• PYTHON NUMPY TUTORIAL ...
PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE
• PYTHON PANDAS TUTORIAL...
MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)
• MATPLOTLIB LIBRARY - P...
PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL
• PYTHON DATABASE CONNEC...
DATA STRUCTURES USING PYTHON (ENGLISH)
• DATA STRUCTURES USING ...
----------------------------------------------------------------------------------------------
Instagram : / sundeepsaradhikanthety

[@ugyenofficial]

Sir! I proudly say you are one of the best teachers of my college education. love you sir

[@sindhusri1886]

Hey sir belongs to which clg

[@sindhusri1886]

Pls tell me

[@dhanyarineesh8699]

Very thanks sir
Clearlyunderstood

[@naveenrose7770]

Very clear explanation. Thank you sir......

[@hasanmougharbel8030]

Hey there, kudos your efforts..Please i have a simple enquiry as a newbie..What is the main difference between cursor and view in sql? Thanks a lot.

[@jsuryakumar8434]

Explanation Awsm sir ❤️

[@DDinesh-p6r]

Thank you so much sir.

[@raghuvarmajadi7736]

Sir, can you take classes for me personally for SQL and python

[@raghuvarmajadi7736]

Please let me know

[@Nikhilg-rs7iv]

ok let me know if he has taught you or not

[@sathwika2424]

Sir explain about cursors in SQL

[@lalithakumari914]

Sir ..is these possible to perform alter commands on views..

[@fog2640]

finished watching

[@jayanthiA-c6n]

Sir explain about embedded sql and dynamic sql

[@ravikiran-je5wm]

Sir,While I'm executing it showing error that duplicate column name
How to correct it sir please

[@prasanthobulasetty9338]

Make vedio how to install sql

[@Nikhilg-rs7iv]

we are querying the view just like we are querying a table. can anyone explain what is the difference then ?

[@balakrishnam507]

How to add new column to the existing view

[@venkateshsolleti2685]

Sir we want complete my sql tutorial

[@souravkarjole7587]

is it difficult to update a view that has multiple table joining ?

[@manchineellavijayalakshmi3517]

Could you please show me sir
Create view for multiple tables

[@karthick2523]

possible

[@vurimisasi5190]

i need to mysql classes