Link to home
Create AccountLog in
Avatar of Jimbo99999
Jimbo99999Flag for United States of America

asked on

SQL Select Query - Case with Count(*)

Good Day Experts!

I think this can be done but I am unsure how to achieve.

In the select portion of my query, I need to query another table and display value X if the count(*) of records in that table with value X is 1...if more than 1 then don't display value.

Here is what I am thinking but can't translate it to a working query:
(Select [Pro Number] from Details when (Select count(*) from Details
     where [Pro Number] = '1234' is = 1)

Can you offer advice?

Thanks,
jimbo99999
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Bhadauria
Saurabh Bhadauria
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of awking00
awking00
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account