how to subtract 2 query in mysql?

Question

I have 2 query. first is

SELECT CASE WHEN WEEKDAY('2017-03-01') <= 5 THEN 5 -  
WEEKDAY('2017-03-01') ELSE 0 END + CASE WHEN WEEKDAY('2017-03-03') <= 5 THEN
WEEKDAY('2017-03-03') + 1 ELSE 5 END + (DATEDIFF('2017-03-03', 
'2017-03-01') + 1 - (7 - WEEKDAY('2017-03-01')) - (WEEKDAY('2017-03-03') + 
1)) DIV 7 * 5 AS w_d

an output of that query is

w_k
 3

and the 2nd one is

  SELECT count(*) FROM attendence WHERE eid=1 and login < ('2017-03-03' + interval 1 day ) AND login >= '2017-03-01' .

an output of that query count(*)

and I want to subtract query1 - 2.

Manish · Accepted Answer · 2017-03-15 11:55:21Z

1

Try this

    Select (
    (SELECT CASE WHEN WEEKDAY('2017-03-01') <= 5 THEN 5 - WEEKDAY('2017-03-01') ELSE 0 END + CASE WHEN WEEKDAY('2017-03-03') <= 5 THEN WEEKDAY('2017-03-03') + 1 ELSE 5 END + (DATEDIFF('2017-03-03', '2017-03-01') + 1 - (7 - WEEKDAY('2017-03-01')) - (WEEKDAY('2017-03-03') + 1)) DIV 7 * 5) - 
(SELECT count() FROM attendence WHERE eid=1 and login < ('2017-03-03' + interval 1 day ) AND login >= '2017-03-01')) AS w_d

answered Mar 15, 2017 at 11:55

Manish

3,6951 gold badge23 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Manish Over a year ago

@Mayur Did this Solve your issue?

Mayur Over a year ago

Hi sir, is it possible, combined or join above 2 query and show a different output of both of them? and similar column of both tables is [ id ]. if possible then can u give me hint about the query. Thank You in Advanced.

Manish Over a year ago

Could you explain what you need with output so that i will directly got your point.

Mayur Over a year ago

I have 4 unrelated query and I want to combine this and get output in tabular format.plz, give me hint for that.

Manish Over a year ago

I think you want to Union . for this please see below link dev.mysql.com/doc/refman/5.7/en/union.html

Collectives™ on Stack Overflow

how to subtract 2 query in mysql?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related