Arshad Ali

Arshad Ali

  • NA
  • 636
  • 33.1k

Subquery Question

Apr 10 2020 3:52 AM
Hello folks,
 
i have the two table 1 is tblquestion and 2 is tblQuestionOption so i want below output so how can i do? 
 
tblQuestion
QID Name Mark
1 ABC 2.0
2 PQR 2.0
3 XYZ 2.0
 
tblQuestionOption
QOID
QID
Option
1 1 A
2 1 B
3 1 C
4 1 D
5 2 A
6 2 B
7 2 C
8 3 A
9 3 D

I want to that O/p using SQL server query.

ID Question Marks
1 ABC?

Options :
A.
B.
C
D
2.0
2 PQR

A.
B.
C.
2.0
3 A. 
D.
2.0

Answers (1)