Difference between Having clause and Group by clause
1. Having Clause : Having Clause is basically like the aggregate function with the GROUP BY clause. The HAVING clause is used instead of WHERE… Read More »
Tag Archives: DBMS-SQL
Difference between Derby and MS SQL Server
1. Derby : Derby is a full-featured, open-source relational database management system (RDBMS) implemented in Java and as the name suggests it is developed by… Read More »
Difference between IBM DB2 and MS SQL
1. IBM DB2 : IBM DB2 is a relational database which was developed by IBM in 1983. It is considered as a family of database… Read More »
Difference between DML and TCL
Prerequisite – DDL, DML, TCL and DCL 1. Data Manipulation Language (DML) : DML is used to manipulate data in the database. For example, insert,… Read More »
SQL Query Complexity
Structured Query Language (SQL) is the language that is used to query Relational Databases. A typical Relational Database consists of tables, where each table has… Read More »
Create, Alter and Drop schema in MS SQL Server
In this article, we will be discussing about schema and how to create, alter and drop the schema. 1. Create schema : A schema is… Read More »
Where clause in MS SQL Server
In this article, where clause will be discussed alongside example. Introduction : To extract the data at times, we need a particular conditions to satisfy.… Read More »
RDBMS Architecture
RDBMS stands for Relational Database Management System and it implements SQL. In the real-world scenario, people use the Relational Database Management System to collect information… Read More »
Distinct clause in MS SQL Server
In this article, we will be discussing about distinct clause in MS SQL Server. Introduction : A table has a maximum of 1000 rows constituted.… Read More »
Advantages and Disadvantages of Using Stored Procedures – SQL
A Stored Procedure is a type of code in SQL that can be stored for later use and can be used many times. So, whenever… Read More »
Introduction of MS SQL Server
Data is a collection of facts and figures and we have humungous data available to the users via intetnet and other sources. To manipulate the… Read More »
Difference between ALTER and UPDATE Command in SQL
1. ALTER Command : Alter SQL command is used to modify, delete or add a column to an existing table in a database. Alter is… Read More »
Flashback Queries
Flashback Query allows users to see the view of past data, If in case some data or table is being deleted by the user, then… Read More »
Difference between SQL and HiveQL
1. Structured Query Language (SQL) : SQL is a domain-specific language used in programming and designed for managing data held in a relational database management… Read More »
SQL queries on FILM Database
Consider the following tables in Film Database: ARTIST (Art_id, Art_Name, Art_Gender) PRODUCER (Prod_id, Prod_Name, Prod_Phone) FILMS (Film_id, Film_Title, Film_Year, Film_Lang, Prod_id) CASTING (Art_id, Film_id, Part)… Read More »
