select stud.name NAME, stud.sid SID from student stud, level

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 / debanjan rudra

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

Answer Posted / debanjan rudra

select stud.name NAME,
stud.sid SID
from student stud,
level lvl
where stud.course = 3
and lvl.level = 'freshman';

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is cursor. write example of it. What are the attributes of cursor.

1456

What is pl sql and why it is used for?

1152

What are the popular database management systems in the it industry?

1035

How to avoid duplicate records in a query?

1045

explain access control lists. : Sql dba

1043

Which data type is a composite type?

1029

What is trigger and stored procedure in sql?

1088

Can we perform dml in function?

1128

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1269

How do you update f as m and m as f from the below table testtable?

1922

Does truncate table reset auto increment?

1044

What is recursive join in sql?

1063

Define a temp table?

1075

What is the purpose of using pl/sql?

1186

Explain locks? : Transact sql

1047