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
15943 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

Can we use join in subquery?

1100

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

1115

what are the 'mysql' command line arguments? : Sql dba

1144

how many tables will create when we create table, what are they? : Sql dba

1081

when is the use of update_statistics command? : Sql dba

1049

what is msql? : Sql dba

994

How to run sql commands in sql*plus?

1186

Which join is like an inner join?

1029

What is data control language (dcl)?

1142

What is sql server and ase?

1028

What is the difference between an inner join and an outer join?

1027

What is the difference between alter trigger and drop trigger statements?

1113

what is offset-fetch filter in tsql? : Transact sql

951

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1171

what are different types of collation sensitivity? : Sql dba

1069