Alternate Of Oracle Minus Command

Question

Post reply

Alternate Of Oracle Minus Command

Jawad Ahmed Siddiqui

Old Hand

Points: 301
More actions
January 23, 2006 at 6:54 am

#92858

Hi
Can some one tell me alternate of Oracle Minus command in SQL server.
i.e.
(select ColA from Tbl_A)
Minus
(select ColA from Tbl_B)
Wishes
Jawad

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

rsharma SSCarpal Tunnel Points: 4865 More actions · Answer 1

rsharma

SSCarpal Tunnel

Points: 4865

January 23, 2006 at 7:56 am

#616417

Use the NOT EXISTS clause.

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 2

Yes, that is usually my choice as well, and the other alternative is a left join filtering the nulls. Test which one works best for your situation. Of course SQL Server 2005 does have the EXCEPT operator which is equivalent to Minus.

Check this old topic for more of this discussion.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Jawad Ahmed Siddiqui Old Hand Points: 301 More actions · Answer 3

Jawad Ahmed Siddiqui

Old Hand

Points: 301

January 24, 2006 at 4:38 am

#616617

Thanks