select s.sid,s.name from student s, level l where s.sid=l.sid and s.cou

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 / raksha

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

Answer Posted / raksha

select s.sid,s.name
from student s,
level l
where s.sid=l.sid
and s.course = 3
and l.level = 'Freshman'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger types in sql?

964

What is rename in sql?

938

Does truncate require commit?

934

How do I view tables in sql developer?

896

What are aggregate functions in sql?

1114

Why indexing is needed?

956

What is meant by user defined function?

1008

Can one improve the performance of sql*loader? : aql loader

998

Why are sql stored procedures used?

1016

Can pl sql procedure have a return statement?

970

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1172

what is blob? : Sql dba

1086

what are the differences among rownum, rank and dense_rank? : Sql dba

1009

Can we perform dml on view?

991

What is recursive join in sql?

967