Describe the use of the INTERSECT operator.

S3odz

wrote...

Posts: 651

Rep:

6 years ago

Describe the use of the INTERSECT operator.

Read 34 times

1 Reply

Report

Related Topics

Solved Describe what the combine and intersect features do for shapes on a slide.
Solved To maximize operator safety during patient exposure, the operator should use fast-speed film. ...
Solved Describe the job of a tour operator.
Solved If a caller to a phone sex operator sounds attractive and is able to arouse the operator's personal ...
Solved The _____ operator could be used in place of INTERSECT if the DBMS does not support it.
Solved Assume you are using the INTERSECT operator to combine the results from two tables with identical ...
Solved UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means ...
Solved The INTERSECT set operator only displays the rows returned by both queries.

Replies

grfrfvfbvr

wrote...

6 years ago

INTERSECT yields only the rows that appear in both tables. As with UNION, the tables must be union-compatible to yield valid results. For example, you cannot use INTERSECT if one of the attributes is numeric and one is character-based. For the rows to be considered the same in both tables and appear in the result of the INTERSECT, the entire rows must be exact duplicates.

Report

New Topic

Quick Reply

Explore

Post your homework questions and get free online help from our incredible volunteers

1122 People Browsing

Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook

Live Chat

AJAX Chat © blueimp.net Integrated with SMF

Related Images

1388

10191

124

Your Opinion

Previous poll results: Who's your favorite biologist?

Bonobos, Chimpanzees, and the 98% DNA Link

Courses by Biology Forums

It's sore throat season, why does my mucus have red spots?

Strange Ingredients Lurking in Doritos Chips

The Toxic Skin and Fungi Defense

Ready to ask a question on Biology Forums? Try it out

Home Search Q & A Board Gallery Resource Library Blog Dictionary Chat	Quick Links Start a Topic Latest Topics Unanswered Questions Courses Study Tools Browse by Textbook	Social Facebook YouTube Community Stats Who's Online Trending Staff	Help About Us Take the Tour Study Tips Posting Guidelines Terms and Policies Contact Us
Biology Forums - Study Force © 2010-2024 \| Powered by SMF \| SMF © 2015, Simple Machines \| Sitemap Biology-Forums.com is not affiliated with any publisher. Book covers, title and author names appear for reference only.