How to write an SQL query using Group...

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

There are 2 comments on the TechTarget story from Sep 29, 2008, titled How to write an SQL query using Group by for row analysis. In it, TechTarget reports that:

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.

Join the discussion below, or Read more at TechTarget.

kishor

India

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

New Delhi, India

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

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form 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.

Java Discussions

Title Updated Last By Comments
HonoIT Content Management System (CMS) to the s... (Jul '16) Jul '16 java 2
News JRE 1.8.0_60 Certified with Oracle E-Business S... (Aug '15) Aug '15 arthur 1
Java 8u20 not removing earlier version... (Aug '14) Aug '14 prabha 1
News Free Java book to download: Beginning J2EE 1.4,... (Sep '07) Jul '14 suvankar 52
News Java Architect (Jul '14) Jul '14 Prasad 1
Contest 100 000 (Jun '14) Jun '14 kermekx 1
News Oracle Patches 51 For Java (Oct '13) Oct '13 java nese 1
More from around the web