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
- 13236 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the current version of postgresql?
Explain the savepoint statement.
What are dml commands?
How do you explain an index?
what is the difference between sql and t-sql? : Transact sql
What is database sql?
How do I filter in sql profiler?
What is java sql package?
What is left inner join in sql?
How can you fetch common records from two tables?
What is a pl/sql block?
Why cross join is used?
Why is a primary key important?
How does one load ebcdic data? : aql loader
