Print Page - SQL: To get a count result, use the SET operator.

Title: SQL: To get a count result, use the SET operator.
Post by: Mobo01 on November 08, 2022, 11:20:51 PM

In SQL Developer, I'm attempting to acquire a count result by using the SET operator.

I need to determine how many instances of "attribute1" exist in "table name1" but not in "table name2."

Essentially, I want the same result as the following query, but with a SET operator.

Code Select Expand
[code]SELECT count(distinct <attribute1>)
FROM <table_name1>
WHERE <attribute1> IS NOT (SELECT <attribute1>
                           FROM <table_name2>);

[/code]

I've looked through many Oracle manuals (//https) and other internet directories (//https) but haven't found satisfactory answers; could somebody kindly assist me?

newLISP Fan Club

Forum => newLISP and the O.S. => Topic started by: Mobo01 on November 08, 2022, 11:20:51 PM