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

How do you declare a constant?

945

What is dynamic query?

957

What are tables and fields?

1013

Can we rollback after truncate?

1012

Can a composite key be null?

959

What is sql query limit?

957

how to use myisamchk to check or repair myisam tables? : Sql dba

956

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1326

What is attribute indicator in pl sql?

1000

Is sql injection illegal?

1003

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

916

what is dbms? : Sql dba

972

What normalization means?

949

Is sql a backend language?

1073

What is procedure explain with example?

937