select s.name,s.sid from student s,level l where s.sid=l.sid and s.course

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

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

Answer Posted / smriti

select s.name,s.sid from student s,level l
where s.sid=l.sid
and s.course=3
and l.level='freshman'

Is This Answer Correct ?

21 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the events on which a database trigger can be based?

1235

How does index help in query performance?

1085

how can we optimize or increase the speed of a mysql select query? : Sql dba

985

What is record data type?

977

When sql appeared?

1146

Are null values same as that of zero or a blank space?

1064

What is sql architecture?

1100

What is sqlcontext?

1141

Is sql injection illegal?

1078

What is crud diagram?

989

What is sql profiling in oracle?

1128

What is the source code of a program?

1118

How can the performance of a trigger be improved?

1087

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1147

What is the usage of nvl function?

1100