I'm trying to select a total value with count and a value with other criteria when i get some values.
So something like
select count() as Z
,(select count() from something where X=1 ) as x,
So i expect to get something like
idx x z
100 20 10
105 30 22
The problem is that i get that a query returned more than 1 value.
What I will do if i don't get some help is create 2 temp table that will have the idx and values and then merger them
but isn't a simpler way?