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
- 15577 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 |
Why stored procedure is faster than query?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What are all the different normalizations?
what is definer rights invoke rights?
What is difference between table and view?
what is a database? : Sql dba
What are wait events. Describe the wait event tables.
which tcp/ip port does sql server run on? : Sql dba
What is java sql driver?
what is the purpose of update command in oracle?
What are the types of triggers in sql?
What is difference between sql and mysql?
-
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)
