DBMS
-
JOINS in SQL
JOINS Using the SELECT command you can retrieve data from several related tables also. But this is possible only if…
Read More » -
DBMS Languages
DBMS Languages DBMS languages are required to practically implement the design of the database. They are of following types: DDL…
Read More » -
FUNCTIONS IN SQL
FUNCTIONS IN SQL SQL functions that can be used to manipulate data. Such functions can be classified into the following…
Read More » -
Update, Delete, DROP commands in SQL
Update, Delete, DROP commands in SQL Update UPDATE is the SQL verb that changes or modifies data values in a…
Read More » -
Aggregate Functions in SQL
Aggregate Functions in SQL SQL aggregate functions such as SUM, AVG, MAX, MIN, COUNT etc. produce a single value for…
Read More » -
Queries in SQL (Select, FROM, WHERE, GROUP BY, ORDER BY, HAVING)
Queries in SQL Queries are a group of commands used to extract data from tables in a database using some…
Read More »