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

Is a secondary key the same as a foreign key?

953

Explain the insert into statements in sql?

935

Why do we need cursor in pl sql?

1078

How do I view a procedure in sql?

907

What is the difference between microsoft sql and mysql?

919

What are the types of queries in sql?

1014

Does sql backup shrink transaction log?

914

Explain the uses of database trigger.

1054

How can you view the errors encountered in a trigger?

915

How do I save a stored procedure?

946

What are tables and fields?

973

How can I change database name in sql?

1001

what is a foreign key ? : Sql dba

1026

What is exit statement?

957

Which sql statement is used to return only different values?

952