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
- 14340 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many scalar data types are supported in pl/sql?
Can I call a procedure inside a function?
How do you update a table in sql?
How to place comments in pl/sql?
How do I run a sql query in pgadmin 4?
What are triggers in sql?
What is pessimistic concurrency control? : Transact sql
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
what is acid property in database? : Sql dba
how can you create an empty table from an existing table? : Sql dba
What is the best sql course?
What makes a good primary key?
Is sql injection illegal?
What are sql triggers used for?
How does cross join work?
