|
View previous topic :: View next topic
|
| Author |
Message |
tmaheswara
New User
Joined: 20 Apr 2010
Posts: 8
Location: pune
|
|
|
|
Hi
I want a query to get the marks of all students who got more than 60 in 6 subjects.If any of the subject they failed dont considering it.Please give me a query regarding this.
Thanks,
Maheswara |
|
| Back to top |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Quote: |
Please give me a query regarding this.
|
Yeh sure. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Please tell us what have you tried? Did it work, per you requirement, or not? Was there some error, yes? What was that? |
|
| Back to top |
|
|
gylbharat
Active Member
.jpg)
Joined: 31 Jul 2009
Posts: 565
Location: Bangalore
|
|
|
|
| Code: |
Select name,sub1,sub2,sub3
from table
where sub1 > 60
and sub2 > 60
and sub3 > 60 ; |
|
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| I want a query to get the marks of all students who got more than 60 in 6 subjects.If any of the subject they failed dont considering it.Please give me a query regarding this. |
given the wording of the question, you will be certainly more at ease in the other forum here
ibmmainframeforum.com/index.php
even if in Your profile You pretend to ..
| Quote: |
Occupation: software professional
Mainframe Skills: cobol,jcl,db2,vsam,cics,TWS |
a software professional, would have never asked a question with so little information to build on |
|
| Back to top |
|
|
|
|
