How to write an SQL query using Group by for row analysis

Full story: TechTarget

I have a table like this std_id skill 1 Java 1 J2EE 1 Struts 2 Java 2 J2EE 3 Java 3 J2EE 3 Struts Now I want to retrieve student IDs for those students that have three skills: Java, J2EE, Struts.

Read All 2 Comments

Comments

Showing posts 1 - 2 of2

kishor

New Delhi, India

SELECT std_id
FROM skills
WHERE skill IN ('Java','J2EE','Struts')
GROUP
BY std_id
HAVING COUNT(*)= 3

Hariharan

Bangalore, India

How to write a sql query for a feed back form(which is using radio buttons) and find the feedback average solution?

	Would you like us to alert you when someone adds a comment?
	(registration is not required)

Showing posts 1 - 2 of2

Type in your comments to post to the forum

Name
(appears on your post)

Comments

Type the numbers you see in the image on the right:

Please note by clicking on "Post Comment" you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Other Recent Java Discussions

Topic	Updated	Last By	Comments
oreilly head first series ebook free download (Feb '09)	Oct '09	sat	8
Java Vs Javascript. The biggest misconception	Oct '09	harryboze	1
for sell d-wade sidekick 3 for just $180usd lrg... (Mar '07)	Sep '09	Gramz	11
Free Java book to download: Beginning J2EE 1.4,... (Sep '07)	Sep '09	anil	44
TOTD #99: Creating a Java EE 6 application usin...	Sep '09	thedailyrevi...	1
Head First Servlets and JSP, Second Edition (Mar '08)	Jul '09	jack	12
MyEclipse IDE gets a speed boost	Jun '09	Joe	1