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 second highest salary from emp table?

Answer Posted / kishor dange

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete a table?

1124


How can use stored procedures in sql?

1193


What is a data definition language?

1197


Where is all the data on the internet stored?

1060


How do you declare a constant?

1018


What is right join in sql?

1158


What are hotfixes and patches?

987


Enlist some predefined exceptions?

1115


What is form and report?

1055


what is collation? : Sql dba

1206


What is dynamic sql in pl sql?

1090


what is the difference between group by and order by in sql? : Sql dba

1188


Describe different types of general function used in sql?

1093


Why partition by is used in sql?

1083


What is difference between stored procedures and application procedures?

1068