SQL

SQL

1. SELECT

   • The SELECT statement is used to select data from a database.
   • SELECT * FROM Customers;

2. FROM

   • This means pick from the specific group

3. OPERATORS

   • Like
     • Search for a pattern
   • Between
     • Between an exclusive range
   • In
     • To specify multiple possible values for a column
   • AND
     • The AND operator displays a record if both the first condition AND the second condition are true.
   • OR
     • The OR operator displays a record if either the first condition OR the second condition is true.

4. DELETE

   • The DELETE statement is used to delete rows in a table.
   • Example DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste' AND ContactName='Maria Anders';

5. DISTINCT WHERE

   • Used to return only distinct values
   • Is used to extract only the records that fulfil a specified criteria
   • SELECT DISTINCT City FROM customers

6. INSERT INTO

   • Used to insert new records in a table
   • INSERT INTO Customers (CustomerName, ContactName, Address)
   • VALUES ("Cardinal", "Tom & Erichsen", "Skagen21");