select stud.name NAME, stud.sid SID from student stud, level

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 / debanjan rudra

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

Answer Posted / debanjan rudra

select stud.name NAME,
stud.sid SID
from student stud,
level lvl
where stud.course = 3
and lvl.level = 'freshman';

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is bitemporal narrowing?

1311

Can instead of triggers be used to fire once for each statement on a view?

962

how to enter numeric values as hex numbers? : Sql dba

1068

What is over () in sql?

969

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1122

How can we optimize a sql query?

1053

Which is better cte or subquery?

1031

What is a trigger in sql?

1207

What are sql built in functions?

940

How to order siblings in oracle hierarchy queries?

1048

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1166

What is an intersect?

1108

What is restrict in sql?

1122

What is before and after trigger?

963

what is the stuff function and how does it differ from the replace function? : Sql dba

1062