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

How to convert comma separated string to array in pl/sql?

1185

What is a boolean in sql?

983

How to place comments in pl/sql?

1159

Is sql procedural language?

968

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

What are the different parts of a package?

1115

Can we rollback delete command?

989

How to select 10 records from a table?

1157

what are the advantages of sql ? : Sql dba

1060

Is sqlite good enough for production?

993

What are functions in sql?

958

What are the different sql languages?

1036

how is exception handling handled in mysql? : Sql dba

1083

what is the difference between a local and a global temporary table? : Sql dba

1073

How do I get sql certification?

975