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

select sal from emp order by salary desc limit 1,1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What type of join is sql join?

988


Can we write ddl statements in functions?

1120


What is scalar and vector?

1008


How do you update a table in sql?

993


What do you mean by query optimization?

1007


Which kind of parameters cannot have a default value in pl sql?

1153


What is trigger in sql?

1107


How do I partition a table in sql?

1138


How do I enable sql encryption?

1035


Which sql most popular?

993


When is a declare statement required?

1146


What are the different types of a subquery?

1053


What is a sql instance vs database?

1121


Can you selectively load only those records that you need? : aql loader

1049


What is the difference between Union and Union all. Which is faster.

1405