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)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if there are two application 1 and 2 having a variable x in both app if client1 changes value of x in 1 app client 2 want reads the value of x from 2 app what resultant value will he get

2272


how to make and display a form without title bar?

1884


What is the problem with .net generics?

1025


Explain about appdomains?

988


Explain some of the disadvantages due to microsoft.net?

935


inprocess vs out process session state : Dot net architecture

894


What is biginteger and when would you use that?

900


Can I customise the trace output?

1028


How to improve the cache performance? : Dot net architecture

886


server.transfer limitation ?

2172


What is password attribute of the textbox control of .net mobile? : Microsoft dot net mobile

898


define cache memory? : Dot net architecture

930


What does this do? Gacutil /l | find /i "corillian"

980


What is textview control of .net mobile? : Microsoft dot net mobile

947


Can you explain server controls in atlas?

927