SELECT S.Name,S.SID FROM Student S, Level L WHERE S.SID=L.SID A

Given two tables Student(SID, Name, Course) and Level(SID,
level) write the SQL statement to get the name and SID of
the student who are taking course = 3 and at freshman level.

Question Posted / guest

9 Answers
15939 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / guest

SELECT S.Name,S.SID
FROM Student S, Level L
WHERE S.SID=L.SID
AND L.level='freshman'
AND S.Course=3

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of nvl function?

1198

discuss about myisam key cache. : Sql dba

1024

How will you distinguish a global variable with a local variable in pl/sql?

1155

what is try_catch block in procedure

1753

what is the difference between undefined value and null value? : Sql dba

1104

What is a relationship and what are they?

1154

What are the operators used in select statements?

1058

What does where 1 1 mean in sql?

1045

How does a self join work?

1132

which tcp/ip port does sql server run on? : Sql dba

1029

what is 'mysqldump'? : Sql dba

1111

What is the difference between function, procedure and package in pl/sql?

1267

What are transaction and its controls?

1041

how to dump a table to a file with 'mysqldump'? : Sql dba

1038

What do we need to check in database testing?

1022