Select Name,SID from Student where SID in(Select SID from level where 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 / vishu

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

Answer Posted / vishu

Select Name,SID from Student
where SID in(Select SID from level where level='freshman')
and Course=3;

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are different types of keys?

1015

How do I run a pl sql program?

1064

What do you mean by rowid?

914

Is big data nosql?

886

What is an escape character in sql?

979

What are sql triggers used for?

956

What are the commands used in sql?

1013

what are properties of a transaction? : Sql dba

1017

what are all the different normalizations? : Sql dba

960

What is a pl/sql block?

1110

Could you please provide oca (oracle 10g) dumps for my certification ?

5070

What is sql character function?

993

How can I make sql query run faster?

960

How to call shell script from pl sql procedure?

1175

Is json a nosql?

914