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

what is a cursor? : Sql dba

1002

how can we destroy the cookie? : Sql dba

993

What is a pl/sql block?

1196

Why is stored procedure faster than query?

934

What do we need to check in database testing?

1002

Which join is like an inner join?

1011

what is primary key? : Sql dba

1008

how to load data files into tables with 'mysqlimport'? : Sql dba

1078

What is faster join or subquery?

997

What type of join is sql join?

962

What is record type in pl sql?

975

How does stored procedure reduce network traffic?

995

what is a record in a database ? : Sql dba

1045

Which operator is used in query for pattern matching?

1071

Write the alter statement to enable all the triggers on the t.students table.

1110