TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
priyanka
NA
215
123.2k
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
Reply
Answers (
5
)
auto increment stored procedure
how to solve this problem calculation.