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 Rhinorhino 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
- Content: Threads
- Order by date
-
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
