5 Queries in SQL

 

                SQL Queries are large in Number. We have multiple Queries and subqueries to get the desired data from the data from server. However, to all these Queries we have selected 5 Queries is basic and essential to create commands.

What are the Top 5 Queries?

                1)  Create,

                2)  Insert Into,

                3)  Update,

                4)  Delete,

                5)  Drop.

1) Create

            

            Create Query is the base where you can be able to create database, create table in SQL server.

While creating table only we can be able to define total number of columns, data types to be entered into the new table created

2) Insert Into

            Insert Into Query helps us to add data into the table from the relevant database.

3) Update

            Update Query is used to amend or edit the existing data in the specific table. Once the data is found error, we can be able to make changes on the data.

4) Delete

            Delete Query is used to delete the data completely from the table. Delete query erases only data it will not delete the table.

5) Drop

            Drop Query is used to remove table without any traces of its existence from the database