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
- 13145 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is latest version of sql?
What is dml statement?
What is the difference between an inner and outer join?
Are stored procedures faster than dynamic sql?
What are pl sql procedures?
What is scalar function in sql?
tell me about various levels of constraint. : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Where is sql database stored?
explain the delete statements in sql
What is a unique constraint?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Write an sql query to select all records from the table?
What is group function in sql?
How many types of normalization are there?
