How to write an SQL query using Group by for row analysis
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.
#1 Nov 3, 2008
WHERE skill IN ('Java','J2EE','Struts')
HAVING COUNT(*)= 3
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?
Add your comments below
|HonoIT Content Management System (CMS) to the s... (Jul '16)||Jul '16||java||2|
|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|
|Free Java book to download: Beginning J2EE 1.4,... (Sep '07)||Jul '14||suvankar||52|
|Java Architect (Jul '14)||Jul '14||Prasad||1|
|Contest 100 000€ (Jun '14)||Jun '14||kermekx||1|
|Oracle Patches 51 For Java (Oct '13)||Oct '13||java nese||1|
Find what you want!
Search Java Forum Now
Copyright © 2017 Topix LLC