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

Write a query to get all details of employee who has maximum
salary from employee table

Answer Posted / vineet

Select * from EMP_TAB where salary = (select max(salary) from EMP_TAB;

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You want to use a perspective in an mdx query. How do you select the perspective?

239


What is a Join and explain its types?

1104


When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

982


what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

952


What is the default fill factor value?

1083


When would you use it?

1000


What is equi join with example?

1134


What are the ways available in sql server to execute sql statements?

1140


What do you mean by recursive stored procedure?

955


What is the beast way to write CTE in SQL Server ?

1048


What is merge?

1021


What is normalization of database? What are its benefits?

1028


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

986


What is tabulation?

956


What do you mean by stored techniques? How would we use it?

1038