answersLogoWhite

0

INTERSECT operator allows you to combine two table expressions into one and return a result set which consists of rows that appear in the results of both table expressions. INTERSECT operator, like UNION operator, removes all duplicated row from the result sets. Unlike the UNION operator, INTERSECT operator operates as AND operator on tables expression. It means data row appears in both table expression will be combined in the result set while UNION operator operates as OR operator (data row appear in one table expression or both will be combined into the result set). The syntax of using INTERSECT operator is like UNION as follows:

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What are the set of operation in dbms?

Relational set operators in dbms uses algebra to manipulates contents in a data base. there are many different operation in Dbms ,they are :- 1.Union 2.intersect 3.Product 4.select 5.Project 6.divide


What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database


Is SQL DBMS or RDBMS?

dbms


What are three types of dbms?

Hierarchical DBMSNetwork DBMSRelational DBMS


What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.


What are the importance of dbms in industrial environment?

importance of DBMS


What is the purpose of dbms?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.


When was Polyhedra DBMS created?

Polyhedra DBMS was created in 1993.


What is the use of dbms?

DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)


What is DBMS?

DBMS is short for database management system . DBMS is the collection of related records.


What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.