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


how to get max salary with employee number by using one select
query and max function ??

Answers were Sorted based on User's Feedback



how to get max salary with employee number by using one select query and max function ??..

Answer / suresh jp

select emp_no,max(salary) over() from table_employee;

Is This Answer Correct ?    7 Yes 0 No

how to get max salary with employee number by using one select query and max function ??..

Answer / nitin sane

select Employee_name,max(Employee_Salary) over() from Employee_test;

Is This Answer Correct ?    2 Yes 0 No

how to get max salary with employee number by using one select query and max function ??..

Answer / mithilesh gatole

Answer -

select MAX(Salary) from Employee
WHERE Salary <> (select MAX(Salary) from Employee )

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More SQL Server Interview Questions

Which language is supported by sql server?

0 Answers  


Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  


difference between Clustered index and non clustered index ?

0 Answers   Infosys,


How to insert data with null values?

0 Answers  


Explain what are the events recorded in a transaction log?

0 Answers  


What is the difference between char and varchar2 datatype in sql?

0 Answers  


Explain difference between cross join and full outer join?

0 Answers  


What stored procedure would you use to view lock information?

0 Answers  


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  


Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,


After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,


How does normalization work?

0 Answers  


Categories