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

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

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

Answer Posted / smriti

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

Is This Answer Correct ?

21 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we enter data in a table in design view?

951

How insert into statements in sql?

1056

what is not null constraint? : Sql dba

1005

How can you load microsoft excel data into oracle? : aql loader

1153

What is pivot in sql?

901

How to run pl/sql statements in sql*plus?

1060

What is a dirty read sql?

1107

Is inner join faster than left join?

1171

What are tables in sql?

1041

When can we use the where clause and the having clause?

1009

What is sql not null constraint?

1008

Can we use loop in sql?

957

Explain the purpose of %type and %rowtype data types with the example?

973

Name the different types of indexes in sql and define them.

1119

What is sql*loader and what is it used for?

1119