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

determine the minimum salary of the employee and his details
who join on the same date

Answer Posted / naresh

select min(sal) from (select sal from emp e1,emp e2 having
e1.hiredate=e2.hiredate);

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is unique key example?

928


Mention the different languages present in dbms

954


How index hunting contributes in improving the query performance?

958


describe middleware applications that ease the connection of databases to web?

934


What is the main purpose of normalization?

1037


Explain the syntax of named procedure?

1000


Explain environment of openedge?

946


What do you mean by aggregate and scalar functions in dbms?

934


What is a foreign key constraint?

1022


What do you understand by the terms entity, entity type, and entity set in dbms?

912


Explain what are super servers?

1122


What is the purpose of database?

866


How do we select distinct values from a table?

929


What is database schema in dbms?

1094


How big is google's database?

918