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 find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Answer Posted / mohsin mukri

select max(salary) as Salary from tbl_Employee
where salary < (select max(salary) from tbl_employee)


sory above post ans is wrong bcoz i forgot to remove = sign

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain different pipelining hazards and how are they eliminated? : Dot net architecture

939


How does an appdomain get created?

955


What is one way operation?

972


Explain about appdomains?

1036


What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile

958


Session State and can i store desirialized object in state server, if yes how and if not why.

1788


What is the purpose of hard disk? : Dot net architecture

967


How do I stop a thread?

965


How do I know when my thread pool work item has completed?

927


Can you explain update progress control?

945


How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts

1073


How can we integrate atlas with web services?

954


Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure on hardware that converts the ascii value to binary? : .NET Architecture

883


What is Object Caching in Visual Studio 2010?

1005


Explain the use of virtual, sealed, override, and abstract.

992