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 / monika

Select salary from emp order by salary desc LIMIT 1,1;

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to return query output in html format? : Sql dba

1023


If a cursor is open, how can we find in a pl/sql block?

1105


how would you get the current date in mysql? : Sql dba

915


What is the starting oracle error number? What is meant by forward declaration in functions?

940


What is where clause in sql?

984


How do I partition in sql?

905


What is the difference between rollback and rollback to statements?

1015


What is an emotional trigger?

932


What are triggers and its uses?

1003


which operator is used in query for pattern matching? : Sql dba

950


What is an example of translating a date into julian format?

1042


Enlist the characteristics of pl/sql?

1744


Why truncate is faster than delete?

1054


What are pl/sql cursor exceptions?

1037


What view means?

931