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

explain about mysql and its features. : Sql dba

1015

Which are the different character-manipulation functions in sql?

1065

Enlist the advantages of sql.

1001

Can we use joins in subquery?

1161

How do I install sql?

993

what does the t-sql command ident_incr does? : Transact sql

1077

What is use of trigger?

933

What is pls_integer in pl sql?

1105

How to use transactions efficiently : transact sql

1058

Is keyword pl sql?

997

Is drop table faster than truncate?

990

What is sqlerrd?

968

How do I start sql profiler?

992

What is sql indexing?

1009

What is pl sql architecture?

959