We use cookies to provide you with a great user experience, analyze traffic and serve targeted promotions.   Learn More   Accept
What are DQL commands?

DQL or Data Query Language commands are used for querying data from database objects. This is only a single command which can result in records from dbo such as tables, views etc and can be subject to projection.

SELECT [ DISTINCT column_1, column_2 .. | * ]
FROM <table_name>
WHERE <query_condition>
GROUP BY <columns_list>
HAVING <condition>
ORDER BY <columns_list> [ ASC | DESC ]

SQL •  Added 2 months ago

What are TCL commands?

TCL or Transaction Control Language commands are used to enforce control on transactions within a database object which might result in a change in the state of data within the dbo.

These are:

  • COMMIT
  • ROLLBACK [ TO save_point_name ]
  • SAVEPOINT save_point_name

SQL •  Added 2 months ago

What are DCL commands?

DCL or Data Control Language commands are used enforce access control to data within the database or database objects.

These are:

  • GRANT <previlige_name> ON <object_name> TO <user_name>
  • REVOKE <previlige_name> ON <object_name> FROM <user_name>

SQL •  Added 2 months ago

What are DML commands?

DML or Data Modification Language commands are used in creating, updating or deleting data from the database objects such as tables.

These are:

  • INSERT INTO TABLE <table_name>
  • UPDATE <table_name> SET <column_name>=<new_value>
  • DELETE [ <column_name> | * ] FROM <table_name>

SQL •  Added 2 months ago

What are DDL commands?

DDL or Data Definition Language commands are used in defining or manipulating database schema. These are used for creating, modifying, and dropping the structure of database objects such as tables.

These are:

  • CREATE TABLE | DATABASE <object_name>
  • ALTER TABLE <table_name>
  • DROP TABLE | DATABASE <object_name>

SQL •  Added 2 months ago

What are the different types of commands in SQL?

There are five types of commands in SQL based on the type of operation they perform:

  1. Data Definition Language - CREATE, ALTER, DROP
  2. Data Modification Language - INSERT, UPDATE, DELETE
  3. Data Control Language - GRANT, REVOKE
  4. Transaction Control Language - COMMIT, ROLLBACK, SAVEPOINT
  5. Data Query Language - SELECT

SQL •  Added 2 months ago

What is the full syntax of a SELECT query?

the full syntax of a SELECT query with all the possible CLAUSES is:


SELECT column_list | *
FROM table_name 
[ JOIN table_name1 ON join_condition ]
[ JOIN table_name2 ON join_condition .. ]
[ WHERE query_condition ]
[ GROUP BY group_by_column_list expression ]
[ HAVING query_condition ]
[ ORDER BY column_list [ ASC | DESC ]
 

SQL •  Added 2 months ago