SQL Query for MySQL

Question

I have 2 tables:

Table:skill
SkillID int(10) unsigned
Description varchar(100)

Table: question
QuestionID int(10) unsigned
SkillID int(10) unsigned
Details varchar(100)

There are many rows in the question table for each skill. I want to run one query listing all skills and only one question for that skill (does not matter which question).

How can that be done?

what if a particular skill has no equivalent in question table? — nawfal
– nawfal, Commented Jun 16, 2013 at 10:46

Prahalad Gaggar · Accepted Answer · 2013-06-16 10:32:46Z

1

FOR MYSQL AND SQLSERVER

SELECT * 
FROM skill S 
INNER JOIN question Q ON S.SkillID=Q.SkillID 
INNER JOIN (
SELECT SkillID ,max(QuestionID) QuestionID
FROM question
GROUP BY SkillID)T
ON S.SkillID =T.SkillID AND Q.QuestionID=T.QuestionID

FOR MYSQL

SELECT SkillID ,max(QuestionID) QuestionID
FROM question
GROUP BY SkillID

answered Jun 16, 2013 at 10:32

Prahalad Gaggar

11.6k17 gold badges58 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matteo Tassinari · Accepted Answer · 2013-06-16 10:35:35Z

0

You can try this:

SELECT SkillID, QuestionID -- or, whatever fields you would need
FROM question
GROUP BY SkillID
ORDER BY RAND()

answered Jun 16, 2013 at 10:35

Matteo Tassinari

18.6k8 gold badges65 silver badges85 bronze badges

Collectives™ on Stack Overflow

SQL Query for MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related