select s.name, c.SID from Student s, level c where s.sid = c.sid

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 / dharmendra singh

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

Answer Posted / dharmendra singh

select s.name,
c.SID
from Student s, level c
where s.sid = c.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

What is the max nvarchar size?

982

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

Is sql dba a good career? : SQL DBA

992

Explain the commit statement.

1160

How can you load multi line records? : aql loader

1076

What is schema in sql?

949

What plvcmt and plvrb does in pl/sql?

1323

Explain the working of foreign key?

1068

How many clustered indexes can be created on a table?

1075

how to enter characters as hex numbers? : Sql dba

1041

how to fetch common records from two tables? : Sql dba

1172

Can variables be used in sql statements?

1033

how can we destroy the cookie? : Sql dba

1012

What mean sql?

1014

Explain how can you save or place your msg in a table?

1028