Home / Tag Archives: DCL Command in DBMS

Tag Archives: DCL Command in DBMS

All Data Control Language(DCL) Command

Data Control Language(DCL) is used to control privilege in Database. To perform any operation in the database, such as for creating tables, sequences or views we need privileges. Privileges are …

Read More »

WHERE clause

Where clause is used to specify condition while retriving data from table. Where clause is used mostly withSelect, Update and Delete query. If condititon specified by where clause is true …

Read More »


Select query is used to retrieve data from a tables. It is the most used SQL query. We can retrieve complete tables, or partial by mentioning conditions using WHERE clause. …

Read More »

Like clause

Like clause is used as condition in SQL query. Like clause compares data with an expression using wildcard operators. It is used to find similar data from the table. Wildcard …

Read More »

Order By Clause

Order by clause is used with Select statement for arranging retrieved data in sorted order. The Order byclause by default sort data in ascending order. To sort data in descending …

Read More »

Group By Clause

Group by clause is used to group the results of a SELECT query based on one or more columns. It is also used with SQL functions to group the result …

Read More »