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
- 13243 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Should I use mbr or gpt?
What type of database is cloud sql?
What is record in pl sql?
What is an intersect?
What is the purpose of the partition table?
What is varchar data type in sql?
What is database white box testing and black box testing?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is information schema in 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 are character functions in sql?
Is join an inner join?
What is audit logout in sql profiler?
How many sql databases can you have on one server?
How do I view tables in mysql?
