SQLTeam.com | Weblogs | Forums

Determine summation data

Determine the total number of companies that have posted jobs and the total number of companies that has never posted jobs in one data set with 2 rows like the one below:

|Clients with Posted Jobs:|NNN|
|
|Clients without Posted Jobs:|NNN|

What happened to my answer
I gave

Just curious
No offense

no your answer really hels me alot, but now i have to solved next query

. Determine the total number of companies that have posted jobs and the total number of companies that has never posted jobs in one data set with 2 rows like the one below:

Clients with Posted Jobs: NNN
Clients without Posted Jobs: nnn

Rupinder

How's the data ???

It's really easy simple answer ..

Depends on how data is there ..

I mean tables columns