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 of two types, System : creating session, table etc are all types of system privilege. Object : any command or query to work on tables …
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 then only the result from table is returned. Syntax for WHERE clause SELECT column-name1, column-name2, column-name3, column-nameN from table-name WHERE [condition]; Example using WHERE clause …
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. Syntax of SELECT Query SELECT column-name1, column-name2, column-name3, column-nameN from table-name; Example for SELECT Query Conside the following Student table, S_id S_Name age address 101 …
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 operators There are two wildcard operators that are used in like clause. Percent sign % : represents zero, one or more than one character. Underscore …
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 order DESC keyword is used withOrder by clause. Syntax of Order By SELECT column-list|* from table-name order by asc|desc; Example using Order by Consider the …
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 from one or more tables. Syntax for using Group by in a statement. SELECT column_name, function(column_name) FROM table_name WHERE condition GROUP BY column_name Example of …