Selecting Top Row with no Null Columns

Is it possible to select a row of data and only show columns where data isn't null?

IE if I have 4 columns:

Column:
ABC
123
NULL
NULL

I should only see ABC, 123

Likewise if the record was:

ABC
NULL
NULL
NULL

I should see only "ABC" as the result.

Essentially I need to: Select TOP 1 * (Rows with no null values) where value = value
lm1189Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chaauCommented:
Yes, it is possible.

Use this simple criteria in the WHERE clause:

Select TOP 1 * where value = value AND Column1 IS NOT NULL

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulfreelancerCommented:
mmmmmmm

the answer above is absolutely correct

but I want to know why you are asking please?

Is this part of a larger query?
0
PortletPaulfreelancerCommented:
perhaps I should be more specific, are you about to do something like this?

select
  fieldnames
, (select top 1 column from sometable
         where column is not null and sometable.x = othertable.y)
from othertable
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.