Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

difference between minus and except in Teradata

Tags:

sql

teradata

what is the difference between minus and except in teradata?

like image 661
Vivart Avatar asked Jan 05 '11 18:01

Vivart

2 Answers

They are equivalent, the difference being that except is ANSI compliant.

like image 181
Joe Stefanelli Avatar answered Oct 25 '22 15:10

Joe Stefanelli

Here is a good link for you:

SQL MINUS or EXCEPT Operator

like image 1
Naveed Avatar answered Oct 25 '22 16:10

Naveed
Sign in to Comment

Related questions

Populating a WPF listbox with items from an SQL (SDF) database
MySQL doesn't use indexes when query over BIT field using bitwise functions
Could not open a connection to SQL Server
Optimize Oracle SQL with large 'IN' clause
mysql CREATE VIEW not working from mysql_query
Standard SQL - CHAR to ASCII
In Oracle, a way for Updates to not lock rows?
SQL Architecture: Is this a justified case to have only one table storing multiple entity types? (using a self JOIN)
sql recursive function - to find managers
sql server 2008 limit on exec statement
New to Dynamic SQL Statements
Simple sqlite question
sql - adding time interval with skipping of certain period
Issues with web application
Using DBNull.Value with SqlParameter without knowing sqlDbType?
difference between key column and non key one
How to get column metadata from a table synonym
How do I use a SQL function inside my SQL query
MySQL Query Browser alternatives [closed]
Does arrangement/order of tables in FROM clause make any difference in improving performance?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!