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
- 15913 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / dharmendra singh
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 |
Post New Answer View All Answers
What is %type in sql?
Why having clause is used in sql?
How to place comments in pl/sql?
Write an sql query to select all records from the table?
How do I count rows in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is varchar example?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Is left join inner or outer by default?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
how does a local variable is defined using t-sql? : Transact sql
What is user defined functions?
How can the performance of a trigger be improved?
which types of join is used in sql widely? : Sql dba
Which software is used for pl sql programming?
