GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  General  >  Interests
Go To First  |  Previous Question  |  Next Question 
 Interests  |  Question 9 of 39    Print  
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?
SELECT Student.name, Student.SID
FROM Student, Level
WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;



  
Total Answers and Comments: 2 Last Update: December 26, 2005   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 10, 2005 14:57:29   #1  
Behnam        

RE: Given two tables Student(SID, Name, Course) and Le...

select Name,SID from student

where Course=3 and SID in ( select SID from Level where Level='freshman' )


 
Is this answer useful? Yes | No
December 26, 2005 06:03:47   #2  
Asheesh pandey        

RE: Given two tables Student(SID, Name, Course) and Le...

I think this is the right answer of the above query:

SELECT Student.name, Student.SID FROM Student, Level

WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;

 
Is this answer useful? Yes | No

 Related Questions

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?
SELECT Student.name, Student.SIDFROM Student, LevelWHERE Student.SID = Level.SIDAND Level.Level = "freshman"AND Student.Course = 3; 

Class ABC{static final float GRAVITATIONAL_CONSTANT = 9.8;public void getConstant(){system.out.println("Gravitational_Constant: " + GRAVITATIONAL_CONSTANT);}} 
Latest Answer : class abc{ final const float PI=3.14f;} ...

Multiple inheritance is a feature in C++ by which one class can be of different types. Say class teachingAssistant is inherited from two classes say teacher and Student. 
Latest Answer : A derived class if it inherits from more than one direct base class,it is call multiple inheritance. ...

Class C extends A implements B{} 

The Object class is the highest-level class in the Java class hierarchy. The Class class is used to represent the classes and interfaces that are loaded by a Java program. 

If a thread attempts to execute a synchronized method or synchronized statement and is unable to acquire an object's lock, it enters the waiting state until the lock becomes available. 

Synchronized methods are methods that are used to control access to an object. A thread only executes a synchronized method after it has acquired the lock for the method's object or class. Synchronized 


 Sponsored Links

 
Related Articles

High Level Data Link Control (HDLC)

High Level Data Link Control HDLC The High Level Data Link Control protocol was developed by the International Organization for Standardization ISO It is used for switched and non switched networks and is a bit oriented architecture The High Level Data Link Control has been accepted and used widel
 

How ERP Improves General Ledger Capacity

How ERP Improves General Ledger Capacity Flexibility quickness and efficiency are the pillars and needs of the modern organization In order to fulfill all the requirements that the market imposes ERP has become an useful utility The general ledger tasks are nowadays one of the most important activit
 

What are the limitations with switch statement?

Switch statement is a powerful statement used to handle many alternatives and provides good presentation for C program. But there are some limitations with switch statement which are given below: Logical operators cannot be used with switch statement. For instance case k>=20: is not allowe
 

goto Statement

Why to avoid goto in C C has goto statement but one must ensure not to use too much of goto statement in their program because its functionality is limited and it is only recommended as a last resort if structured solutions are much more complicated. First let us understand the goto statement, its
 

ITIL Service Level Management

Service Level Management Service level management (SLM) is one of the five components in the ITIL service delivery area. It is known as the most significant set of processes in the ITIL framework. The SLM processes provide a structure that defines services, and also defines which service levels are
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Things To Watch Out For Your Student Loan

Things To Watch Out For Your Student Loan Getting into a college program is not an easy thing to do Although a college degree is your ticket to a future career and financial stability it nonetheless comes with a price tag And that price tag is not too easy to pay off especially if you don’
 

Disadvantages Of Student Loan Consolidation

Disadvantages Of Student Loan Consolidation Student loan is considered by some to be the solution in getting a college education But what isn’ t generally known is that there are disadvantages involved in getting a student loan consolidation when you need to repay your debts in the future
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape