Database

SELECT UPC, COUNT(DISTINCT OrderHeaderId)
FROM OrderDetail
GROUP BY UPC
HAVING COUNT(DISTINCT OrderHeaderId) > 1

_Flaviu wrote:

it is possible to achieve that by SQL ?

SELECT column_name(s), 0 As QueryPart FROM table1

UNION ALL

SELECT column_name(s), 1 As QueryPart FROM table2

ORDER BY QueryPart, SomeOtherColumn

WITH cteUnion As
(
    SELECT column_names(s), 0 As QueryPart FROM table1
    
    UNION ALL
    
    SELECT column_name(s), 1 As QueryPart FROM table2
)
SELECT
    column_name(s)
FROM
    cteUnion
ORDER BY
    QueryPart,
    SomeOtherColumn
;

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM
    (SELECT column_name(s) FROM table2 ORDER BY 3)

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT b.id, b.name FROM
    (SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416)

SQL
Executing SQL directly; no cursor.
Incorrect syntax near ')'.
Statement(s) could not be prepared.

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT S.id, S.name FROM
    (SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416) AS S

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT S.id, S.name FROM
    (SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416) AS S

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT S.id, S.name FROM
    (SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416 ORDER BY 2) AS S

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

k5054 wrote:

will be returned in the insertion order?