Data Query Lanage(DQL): Multiple Table Search-Join && Union
JOIN Combine rows from two or more tables SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER...
2020, May 24 — 1 minute readJOIN Combine rows from two or more tables SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER...
2020, May 24 — 1 minute readView is a virtual table. It builds on one or more tables by SQL statements....
2020, May 23 — 1 minute readPre-Prepared SQL statements that can be reused. CREATE PROCEDURE procedure_name AS sql_statement GO; Execute EXEC...
2020, May 23 — 1 minute readStructured Query Language is a programming language used to communicate with Relational Database Management System....
2020, May 23 — 1 minute readSELECT SELECT column1, column2, ... FROM table_name; SELECT * FROM table_name; Alias SELECT * FROM...
2020, May 23 — 2 minute readData Manipulation Language(DML) Insert data INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2,...
2020, May 23 — 1 minute readData Definition Language(DDL) Used to create or modify database schema. CREATE Create database CREATE DATABASE...
2020, May 23 — 4 minute readString Types CHAR(size) letters, numbers and special characters fixed length size: from 0 to 255,...
2020, May 23 — 1 minute read