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.

Answers were Sorted based on User's Feedback



Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

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

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

Answer / vishu

Select Name,SID from Student
where SID in(Select SID from level where level='freshman')
and Course=3;

Is This Answer Correct ?    5 Yes 1 No

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

Answer / supreeth

SELECT Student.name, Student.SID
FROM Student, Level
WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;

Is This Answer Correct ?    6 Yes 3 No

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

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

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

Answer / dharmendra singh

select s.name,
c.SID
from Student s, level c
where s.sid = c.sid
and s.course = 3
and l.level = 'freshman';

Is This Answer Correct ?    0 Yes 0 No

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

Answer / raksha

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

Is This Answer Correct ?    0 Yes 0 No

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

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

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

Answer / nagendra

select e.sid, e.name from student e, level d where e.course
= 3 and d.level = 'FISHERMAN'

Is This Answer Correct ?    1 Yes 3 No

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get th..

Answer / debanjan rudra

select stud.name NAME,
stud.sid SID
from student stud,
level lvl
where stud.course = 3
and lvl.level = 'freshman';

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is synonyms?

0 Answers  


What is normalization sql?

0 Answers  


What are the components of a PL/SQL block ?

3 Answers  


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  


How does postgresql compare to "nosql"?

0 Answers  






What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  


Explain what is a column in a table?

0 Answers  


How do you define a foreign key?

0 Answers  


How do I count rows in sql?

0 Answers  


Explain the steps needed to create the scheduled job?

0 Answers  


ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  


Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,


Categories