SELECT S.Name ,S.SID FROM Student S INNER JOIN Level L ON S.SID=L

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 / ani

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

Answer Posted / ani

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does rownum mean in sql?

1026

What is raw datatype in sql?

1046

What are the sql commands?

1182

What is normalization sql?

1060

What is a constraint?

1023

What is the basic form of sql query?

944

What are tables in sql?

1066

What is trigger in sql and its types?

1058

What are the different dcl commands in sql?

1174

What are the different schemas objects that can be created using pl/sql?

1029

What is meaning of <> in sql?

1070

What are the main features of cursor?

1071

what is the use of set statement in tsql? : Transact sql

1011

What does select top 1 do in sql?

1098

How do I run sql profiler?

1073