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
16122 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 difference between sum and count in sql?

1028

What is %type in sql?

1005

What is pragma in pl sql?

1175

Can we call procedure in select statement?

1105

What is the difference between microsoft sql and mysql?

1011

What is difference between function and trigger?

1103

What are the constraints available in sql?

1083

What is the difference between nvl function, ifnull function, and isnull function?

1148

Is sql dba a good career? : SQL DBA

1043

What is partition by in sql?

1124

Why do we use joins?

1091

What is pl sql script?

1074

Explain aggregate functions are available there in sql?

1046

Mention what are the benefits of pl/sql packages?

1149

what is a primary key? : Sql dba

1082