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'

Answer / vishu

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

Answer / supreeth

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

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

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';

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'

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'

Answer / nagendra

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

Answer / debanjan rudra

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

Is left join same as join?

0 Answers  

What are the three pl sql block types?

0 Answers  

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

Does execute immediate commit?

0 Answers  

cursor types? explain with example programs?

1 Answers   HP,

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

Why self join is used in sql?

0 Answers  

What is PL/SQL Records?

0 Answers  

How do you update f as m and m as f from the below table testtable?

0 Answers  

Is primary key an index?

0 Answers  

Which is better join or subquery?

0 Answers  

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,