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

Why left join is used in sql?

977

how to do backup entire database? : Transact sql

1140

What does t sql mean?

941

How to write pl sql program in mysql command prompt?

1089

explain the difference between delete , truncate and drop commands? : Sql dba

1089

What is the difference between a procedure and a function?

1103

What is a variable in sql?

997

How can you tell the difference between an index and a view?

930

what is table? : Sql dba

1056

What is the difference between delete and truncate statement in sql?

1065

What is oracle sql developer?

1041

What do you know by pl/sql cursors?

1099

What does select top 1 do in sql?

1084

How many parts of a pl sql block are optional?

1125

What is a schema sql?

1145