select e.sid, e.name from student e, level d where e.course = 3 and d.leve

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

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

Answer Posted / nagendra

select e.sid, e.name from student e, level d where e.course
= 3 and d.level = 'FISHERMAN'

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pl sql and why it is used for?

1098

Is sql developer case sensitive?

978

What is pl sql architecture?

944

What are the two characteristics of a primary key?

958

Mention what plvcmt and plvrb does in pl/sql?

1113

what are properties of a transaction? : Sql dba

1076

What types of commands can be executed in sql*plus?

1090

What is a design view?

915

How does a self join work?

1075

What does select top 1 do in sql?

1077

What are the two parts of design view?

1003

How many rows can sqlite handle?

1091

what is sub-query? : Transact sql

1081

Which kind of parameters cannot have a default value in pl sql?

1121

What is input buffer in sql*plus?

1190