Select Statement in SQL

Select Statement - used to select data from a database.

syntax:
       to select all record in database.
           Select * from tableName 
     
      to select column in the database.
          Select Column1, Column2, Column3......
          from tableName

SQL - structured query language

What is SQL?

• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases
• SQL is an ANSI (American National Standards Institute) standard

---

What Can SQL do?

• SQL can execute queries against a database
• SQL can retrieve data from a database
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures, and views