select s.sid,s.name from student s, level l where s.sid=l.sid and s.cou

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

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

Answer Posted / raksha

select s.sid,s.name
from student s,
level l
where s.sid=l.sid
and s.course = 3
and l.level = 'Freshman'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is information schema in sql?

1028

Can a commit statement be executed as part of a trigger?

1008

What is count * in sql?

950

How do I run sql?

1106

What does bitemporal mean?

1021

What is flag in sql?

995

What is sqlcommand?

976

How do you modify a column in sql?

958

Define concurrency control. : Transact sql

1122

What is program debugging?

1158

Enlist the data types that can be used in pl/sql?

1025

What is the use of %rowtype?

993

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1011

What is minus?

949

Why is pl sql needed?

888