select e.sid, e.name from student e, level d where e.course = 3 and d.leve

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

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

Answer Posted / nagendra

select e.sid, e.name from student e, level d where e.course
= 3 and d.level = 'FISHERMAN'

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the primary use of normalization?

1002

How do I find duplicates in a single column in sql?

1020

Which version of sql do I have?

1055

How do you exit in sql?

1106

How to run sql statements with oracle sql developer?

1063

What is anonymous block in sql?

1120

how to shut down the server with 'mysqladmin'? : Sql dba

1009

How do sql databases work?

992

Is pl sql a scripting language?

1028

What are the uses of sysdate and user keywords?

1103

How can get second highest salary in sql?

988

how tsql statements can be written and submitted to the database engine? : Transact sql

993

How can triggers be used for the table auditing?

1068

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1031

Explain what is sql*plus?

1140