Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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 inline view?

15 Answers  

define primary key & secondary key?

2 Answers  

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

What are the benefits of pl sql?

0 Answers  

What does stand for in sql?

0 Answers  

What are pl/sql packages?

0 Answers  

Explain what is sql*plus?

0 Answers  

Enlist the characteristics of pl/sql?

0 Answers  

What is difference between my sql and sql?

0 Answers  

How can a pl sql block be executed?

0 Answers  

Explain clause in sql?

0 Answers  

please explain database architecture..

1 Answers   Infosys,

For more SQL PLSQL Interview Questions Click Here
Categories