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

How do you exit in sql?

1105

what is a database transaction? : Sql dba

1169

Mention what does plv msg allows you to do?

1107

Explain what is rdbms?

1027

What is compiled query?

1031

how many groups of data types? : Sql dba

1020

Is time a data type in sql?

901

What are the types of keys?

989

What are sql functions? Describe in brief different types of sql functions?

1100

How do I remove all records from a table?

1067

What is the difference between sql, mysql and sql server?

1097

Explain the working of foreign key?

1060

What are primary key and foreign key and how they work?

973

What is recursive join in sql?

1004

What are local and global Indexes and where they are useful.

1437