SELECT S.Name,S.SID FROM Student S, Level L WHERE S.SID=L.SID A

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

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

Answer Posted / guest

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

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are dml statements autocommit?

984

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

916

Name some usages of database trigger?

966

What is forward declaration in pl sql?

1006

What are the types of operators available in sql?

1009

What is trigger in sql and its types?

990

What does the sign mean in sql?

918

What is sap sql anywhere?

972

what are the differences between char and nchar? : Sql dba

1055

What is the need of merge statement?

987

Is record in oracle pl sql?

902

What is parallel hint?

1220

Why cross join is used?

1021

What is sql indexing?

964

What does t sql mean?

896