priyanka

priyanka

  • NA
  • 215
  • 119.5k

Find Only Non Null Value from Multiple Row

Jul 19 2017 2:26 AM
I have a database structure like this:
 
Ans     Qid
Null       1
8           1
Null       1
Null       1
 
 
I want to find only non null value 8 based on qid,rather than both null and non null value on bais of qid.
 
 i.e my output shouid be like this:
 
Ans   Qid
8         1
 
Please suggest me some sql server query to achieve this
 

Answers (5)