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.
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 does over partition by mean in sql?
What is the difference between distinct and unique in sql?
What is insert command in sql?
Explain autonomous transaction.
What is the difference between clustered and non-clustered index in sql?
Which function is used to return remainder in a division operator in sql?
explain the difference between bool, tinyint and bit. : Sql dba
Is like operator in sql case sensitive?
Which one is better sql or oracle?
Is it possible to sort a column using a column alias?
Is sql a programming?
What makes a good primary key?
Explian rowid, rownum? What are the psoducolumns we have?
What is difference between sql and oracle?
What is pl sql and why it is used for?