Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

How do you declare a constant?

960


What trigger means?

977


what are string data types? : Sql dba

1039


What does varchar include?

947


What is user in sql?

1018


How many commands are there in sql?

1028


What is denormalization in a database?

1053


How does cross join work?

951


Does view store data in sql?

962


Explain the the update statement in sql?

1036


Explain what is sql*plus?

1140


Which function is used to return remainder in a division operator in sql?

1139


Where can I learn sql for free?

984


how to write date and time literals? : Sql dba

959


What is cold data?

958