Перейти к содержимому

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

Sundeep Saradhi Kanthety

0:00 / 0:00

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

66 718 просмотров · 4 г. назад
Sundeep Saradhi Kanthety
679 тыс. подписчиков
66 718 просмотров · 4 г. назад
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 & INSTALL MySQL IN WINDOWS 10   DATABASE MANAGEMENT SYSTEM    • DATABASE MANAGEMENT SYSTEM   PYTHON PROGRAMS    • PYTHON PROGRAMS   C PROGRAMMING    • 01 - VARIABLES & CONSTANTS in C PROGRAMMING   CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS    • Core Java Full Course for Beginners 🚀 | Le...   HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS    • Learn HTML in 4 Hours 🔥 Full Tutorial with...   LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS    • Learn CSS with practical explanation in 3 ...   JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT    • Learn JavaScript in 7 Hours 🕖 | Complete J...   PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో)    • తెలుగులో Python నేర్చుకోండి | Learn Python...   PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో)    • Python OOPs, Modules & Exception Handling ...   PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU    • Python NumPy Full Tutorial in Telugu (తెలు...   PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE    • Python Pandas Full Tutorial in Telugu (తెల...   MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH)    • MATPLOTLIB LIBRARY - PYTHON PROGRAMMING   PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL    • PYTHON DATABASE CONNECTIVITY - MYSQL & MS-...   DATA STRUCTURES USING PYTHON (ENGLISH)    • DATA STRUCTURES USING PYTHON   ---------------------------------------------------------------------------------------------- Instagram :   / sundeepsaradhikanthety