How to add results of two select commands in same query

Question

I currently have two select commands as per below  What I would like to do is to add the results together in the SQL query rather than the variables in code   select sum hours  from resource  select sum hours  from projects-time    Is it possible to have both in the same SQL and output a sum of both results

User · Answer

If you want to make multiple operation use   select  sel1 s1 sel2 s2    select sum hours  s1 from resource  sel1 join   select sum hours  s2 from projects-time sel2 on sel1 s1 sel2 s2

User · Answer

UNION ALL once  aggregate once   SELECT sum hours  AS total hours FROM        SELECT hours FROM resource    UNION ALL    SELECT hours FROM  projects-time  -- illegal name without quotes in most RDBMS      x

User · Answer

Yes  It is possible  D  SELECT  SUM totalHours  totalHours FROM                        select sum hours  totalHours from resource             UNION ALL             select sum hours  totalHours from projects-time           s   As a sidenote  the tablename projects-time must be delimited to avoid syntax error  Delimiter symbols vary on RDBMS you are using

User · Answer

Something simple like this can be done using subqueries in the select clause   select   select sum hours  from resource             select sum hours  from projects-time           as totalHours   For such a simple query as this  such a subselect is reasonable   In some databases  you might have to add from dual for the query to compile   If you want to output each individually   select  select sum hours  from resource  as ResourceHours          select sum hours  from projects-time  as ProjectHours   If you want both and the sum  a subquery is handy   select ResourceHours  ProjectHours   ResourceHours ProjecctHours  as TotalHours from  select  select sum hours  from resource  as ResourceHours                select sum hours  from projects-time  as ProjectHours        t

User · Answer

Repeat for Multiple aggregations like   SELECT sum AMOUNT  AS TOTAL AMOUNT FROM        SELECT AMOUNT FROM table 1     UNION ALL      SELECT AMOUNT FROM table 2      UNION ALL      SELECT ASSURED SUM FROM table 3

[sql] How to add results of two select commands in same query

Examples related to sql

Examples related to sqlite

Examples related to select