Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
Find Only Non Null Value from Multiple Row
priyanka
Jul 19 2017 2:26 AM
176
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
auto increment stored procedure
how to solve this problem calculation.