Database

_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?

Alex Dunlop wrote:

My main problem is concurrent database read/write capability

Alex Dunlop wrote:

What about SQL Server? Or Mongodb?

Alex Dunlop wrote:

users will be registered on the database for further analysis or detecting any criminal materials or misuses.

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Eddy Vluggen wrote:

You might want to consult a lawyer, not a software-dev.