Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 9 Answers
- 15594 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How to remove duplicate rows from a table?.
Explain polymorphism in pl/sql.
Can you alter start with clause?
Explain what is an index?
How do you declare a constant?
How to Execute a Package in PL/SQL.?
What is the difference between sql and isql*plus?
What are the types of variables use in pl sql?
What is bind variable in pl sql?
What is the diffrence between IN and EXISTS.which one is faster.
when a procedure /package is getting invalidated?
Is nosql faster than sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
