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...

Find all employees in Dept “Marketing”.

Answer Posted / guneetinder singh

select ename from emp where deptname = 'Marketing'

ename = employee name.
deptname= department name

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

master table and child table performances and comparisons in Oracle ?

2199


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398


What happens if recursive calls get out of control?

1140


What are the different editions of oracle?

1180


How to connect to the server with user account: sys?

1063


What is oracle rownum?

1018


Why use resource manager in Oracle?

1174


What is a sub query and what are the different types of subqueries?

1173


What are triggers in oracle?

1099


What are a collation and state the different types of collation sensitivity?

1243


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1138


What is the difference between sharding and partitioning?

1041


How does Oracle guarantee data integrity of data changes?

2458


How a database is related to tablespaces?

1084


How do I find my oracle client driver version?

1098