Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: nebakanezer
- Order by date
-
-
H
Yes with the module name as well, but i tried: select max(emark), mname from result, module where result.mcode = module.mcode; and it says not a single-group function- nebakanezer
- Post #7
- Forum: ANSI_SQL
-
H
Still does not work. As i said im trying to find the highest exam mark. My logic was to do a comparrison with X Y cmark from the results table. But i also need to join the result and module tables in order to display the module name. Thats it really, dont know if i am approaching it in the...- nebakanezer
- Post #5
- Forum: ANSI_SQL
-
H
thanx for the reply. I tried this but still no luck. SQL> select mname, X.cmark, Y.cmark from result X,result Y, module 2 where result X.mcode and result Y.mocode = module.mcode 3 and X.cmark > Y.cmark; where result X.mcode and result Y.mocode = module.mcode * ERROR at...- nebakanezer
- Post #3
- Forum: ANSI_SQL
-
H
Hi, im trying to find the module with the highest exam mark. Anyone spot the error. SQL> select mname, X.cmark, Y.cmark from result X,result Y, module 2 where result.mcode = module.mcode 3 and X.cmark > Y.cmark; where result.mcode = module.mcode * ERROR at line 2: ORA-00904...- nebakanezer
- Thread
- Replies: 9
- Forum: ANSI_SQL
-
-
Date compareing?
Hi im trying to find twins who were born on the same day, iv tried select X.surname, X.forenames, X.dob, Y.surname, Y.forenames from student X, student Y where X.surname = Y.surname and X.dob = Y.dob; and also select surname,forenames,dob from student where surname = surname and...- nebakanezer
- Thread
- Replies: 5
- Forum: ANSI_SQL
