Click here to Skip to main content
15,442,531 members
Home / Discussions / Database
   

Database

 
QuestionMySQL Query Example/Solution of Oracle Query Pin
M Riaz Bashir19-Dec-14 5:08
MemberM Riaz Bashir19-Dec-14 5:08 
QuestionRe: MySQL Query Example/Solution of Oracle Query Pin
Eddy Vluggen19-Dec-14 5:20
professionalEddy Vluggen19-Dec-14 5:20 
AnswerRe: MySQL Query Example/Solution of Oracle Query Pin
Jörgen Andersson19-Dec-14 7:17
professionalJörgen Andersson19-Dec-14 7:17 
GeneralRe: MySQL Query Example/Solution of Oracle Query Pin
Eddy Vluggen19-Dec-14 7:31
professionalEddy Vluggen19-Dec-14 7:31 
GeneralRe: MySQL Query Example/Solution of Oracle Query Pin
Jörgen Andersson19-Dec-14 8:06
professionalJörgen Andersson19-Dec-14 8:06 
GeneralRe: MySQL Query Example/Solution of Oracle Query Pin
M Riaz Bashir20-Dec-14 7:26
MemberM Riaz Bashir20-Dec-14 7:26 
GeneralRe: MySQL Query Example/Solution of Oracle Query Pin
Jörgen Andersson4-Jan-15 2:45
professionalJörgen Andersson4-Jan-15 2:45 
QuestionThe SQL problem about student majoring courses Pin
tzungshian18-Dec-14 0:40
Membertzungshian18-Dec-14 0:40 
COURSE (CourseID, Cname, Ccredit)
TEACHER (TeacherID, Tname, Toffice)
STUDENT (StudentID, Sname, Sclass)
TAKE_COURSES (CourseID, TeacherID, StudentID, Score, ClassRoom)

Question:
List all the name of students whose subjects are all past.

The answer is:
SELECT Sname
FROM STUDENT
WHERE NOT EXISTS(
SELECT *
FROM TAKE_COURSE
WHERE TAKE_COURSE.StudentID= STUDENT.StudentID AND Score<60)

I can't understand this sentence
WHERE TAKE_COURSE.StudentID= STUDENT.StudentID AND Score<60)
Can anyone please tell me how to resolve it?
Thank you very much.
AnswerRe: The SQL problem about student majoring courses Pin
Richard MacCutchan18-Dec-14 1:39
mveRichard MacCutchan18-Dec-14 1:39 
GeneralRe: The SQL problem about student majoring courses Pin
tzungshian18-Dec-14 14:32
Membertzungshian18-Dec-14 14:32 
QuestionLogin Problem in sql server 2008 r2 Pin
Member 1131655316-Dec-14 19:48
MemberMember 1131655316-Dec-14 19:48 
AnswerRe: Login Problem in sql server 2008 r2 Pin
Mycroft Holmes16-Dec-14 21:14
professionalMycroft Holmes16-Dec-14 21:14 
QuestionRe: Login Problem in sql server 2008 r2 Pin
ZurdoDev17-Dec-14 3:17
professionalZurdoDev17-Dec-14 3:17 
QuestionHow to create data copies SQL Server 2005 Express ? Pin
Member 245846716-Dec-14 17:03
MemberMember 245846716-Dec-14 17:03 
AnswerRe: How to create data copies SQL Server 2005 Express ? Pin
Mycroft Holmes16-Dec-14 18:35
professionalMycroft Holmes16-Dec-14 18:35 
GeneralRe: How to create data copies SQL Server 2005 Express ? Pin
Member 245846716-Dec-14 22:13
MemberMember 245846716-Dec-14 22:13 
GeneralRe: How to create data copies SQL Server 2005 Express ? Pin
Mycroft Holmes17-Dec-14 11:49
professionalMycroft Holmes17-Dec-14 11:49 
GeneralRe: How to create data copies SQL Server 2005 Express ? Pin
Member 245846717-Dec-14 20:59
MemberMember 245846717-Dec-14 20:59 
GeneralRe: How to create data copies SQL Server 2005 Express ? Pin
Mycroft Holmes17-Dec-14 21:39
professionalMycroft Holmes17-Dec-14 21:39 
GeneralRe: How to create data copies SQL Server 2005 Express ? Pin
Member 245846721-Dec-14 17:01
MemberMember 245846721-Dec-14 17:01 
QuestionChange cursor to common table Pin
Amr Mohammad15-Dec-14 1:16
MemberAmr Mohammad15-Dec-14 1:16 
SuggestionRe: Change cursor to common table Pin
Richard Deeming15-Dec-14 2:56
mveRichard Deeming15-Dec-14 2:56 
GeneralRe: Change cursor to common table Pin
Amr Mohammad15-Dec-14 8:22
MemberAmr Mohammad15-Dec-14 8:22 
AnswerRe: Change cursor to common table Pin
Richard Deeming15-Dec-14 10:32
mveRichard Deeming15-Dec-14 10:32 
GeneralRe: Change cursor to common table Pin
Amr Mohammad16-Dec-14 21:40
MemberAmr Mohammad16-Dec-14 21:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.