Home -> Usenet -> comp.databases.oracle -> What's the correct select

What's the correct select

From: Jaff Fan <jaff_at_tang.ca>
Date: Sat, 23 Nov 2002 02:07:35 GMT
Message-ID: <HpBD9.149581$oRV.82069_at_news04.bloor.is.net.cable.rogers.com> 






Hi all,



Here is a table marks:



std_id        number(4)

std_name   varchar2(30)
subj1        number(3)
subj2        number(3)





select statment:



select std_id, subj1+subj2 Total_Marks  from marks
where subj1 > avg(subj1) and subj2 > avg(subj2)
order by std_id



The statment returns an error at where clause, so what's the correct where
clause



Thanks



Jaff
Received on Sat Nov 23 2002 - 03:07:35 CET












Original text of this message