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

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

how will you find out the last three records in a table with n no of records and delete them

3 Answers  

Does mysql support pl sql?

0 Answers  

how can i create a user defined datatype

3 Answers  

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

What is sql profiler in oracle?

0 Answers  

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

what tools available for managing mysql server? : Sql dba

0 Answers  

What are predefined functions in sql?

0 Answers  

What does varchar include?

0 Answers  

What are different clauses used in sql?

0 Answers