SELECT S.Name ,S.SID FROM Student S INNER JOIN Level L ON S.SID=L

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

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

Answer Posted / ani

SELECT
S.Name
,S.SID
FROM Student S
INNER JOIN Level L ON S.SID=L.SID
WHERE S.Course=3 AND L.level='freshman'

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1061

Is primary key always clustered index?

1013

how many groups of data types? : Sql dba

1015

How to return multiple rows from the stored procedure?

961

What is a mutating table and a constraining table?

1100

What is an inner join sql?

1021

What is a nested table in word?

952

Explain the difference between drop and truncate commands in sql?

1035

what is heap table? : Sql dba

1101

What is a ddl command?

1079

Does truncate need commit?

938

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1109

What is string join?

970

What is sql integrity?

1142

What is sql mysql pl sql oracle?

1063