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 / nirjesh pandey

select salary from employee order by salary DESC LIMIT(1,1);

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster subquery or join?

1217


What is mutating error in pl sql?

1013


Does sql full backup truncate logs?

1014


What is sql and its types?

1180


explain advantages of innodb over myisam. : Sql dba

1126


What is benefit of creating memory optimized table?

970


What is dml with example?

1085


How many types of primary keys are there?

1036


Why procedure is used in sql?

1032


Can primary key be changed?

903


What is sql injection owasp?

1060


What are % type and % rowtype?

1028


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1065


How do I add a database to sql?

1125


Explain scalar functions in sql?

1064