Re: Help on query

Tue, 22 May 2001 01:40:41 -0700

Title: Help on query
Hi,
I think It gives the right respose for you:
 
select a.std_no from exam a ,exam b
where (a.subject='CHEM' and a.POINT='A') and (b.subject='PHYSIC' and b.POINT='A')
and a.std_no=b.std_no;
----- Original Message -----
Sent: Tuesday, May 22, 2001 11:31 AM
Subject: Help on query

Dear gurus,

I have a table :
Tabel Exam
STD_NO SUBJECT POINT
====== ======= =====
001    CHEM     A
001    PHYSIC   A
001    BIOLOGY  A

002    CHEM     A
002    PHYSIC   B
002    BIOLOGY  A

003    CHEM     A
003    PHYSIC   A
003    BIOLOGY  B

What is the SQL query to retrieve STD_NO which have CHEM = A and PHYSIC = A?

The output should be :
STD_NO
======
001
003

TIA,


Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
INDONESIA
phone : +62 (31) 8708456 ext.113
visit [ORAID!] http://oraid.iwarp.com

Reply via email to