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

How many databases can sql express handle?

989

Is sql database free?

983

What is oracle and pl sql?

1120

How to avoid duplicate records in a query?

1009

What is trigger in flip flop?

1007

What does pl sql developer do?

935

what is myisam? : Sql dba

1087

How do I view an execution plan in sql?

988

What is constant in pl sql?

1024

What is scalar and vector?

1005

how to fetch alternate records from a table? : Sql dba

1114

What is meant by user defined function?

1053

Can we write ddl statements in functions?

1118

how to use 'mysql' to run sql statements? : Sql dba

1055

what is an index? : Sql dba

999