SQL Queries (1) The SQL CREATE TABLE Statement: Syntax CREATE TABLE table_name (column1 datatype,column2 datatype,column3 datatype,....); Example CREATE TABLE Persons (PersonID int, LastName varchar(255),FirstName varchar(255),Address varchar(255), City varchar(255)); (2) SQL INSERT INTO Statement INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1,value2, value3, ...); Example INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode,Country)VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway'); (3) SQL SELECT Statement (a) SELECT column1, column2, ... FROM table_name; (b) SELECT * FROM table_name; Example (a) SELECT CustomerName, City FROM Customers; (b) SELECT * FROM Customers; (4) SQL SELECT DISTINCT Statement SELECT DISTINCT column1, column2, ... FROM table_name; Example SELECT Country FROM Customers; (
This blog is mainly helpful to those who are preparing for government exam and for those who get admission in B.com or M.com. Information of all government jobs, daily news papers, competitive exam materials, study videos, government GR, syllabus of B.Com & M.Com, paper bank of Kutch university, paper bank and assignments of IGNOU & BAOU, Gujarati vyakran tutorial, computer shortcut keys, scholarships details.