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

select distinct emp_sal from emp where 1 order by emp_sal
desc limit 1,1

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between inner join and cross join?

1019


What is the use of sqldataadapter?

1026


What type of join is sql join?

1024


Could you please provide oca (oracle 10g) dumps for my certification ?

5244


Explain isolation levels. : Transact sql

1109


Can you skip header records while loading? : aql loader

1102


What are types of exception?

963


What is cursor status?

1238


What does rownum mean in sql?

1091


Which constraints we can use while creating database in sql?

1121


Can we write ddl statements in functions?

1185


What does stand for in sql?

1026


Which are the different case manipulation functions in sql?

1077


What is the sql case statement?

1055


How to pipe multiline string to isql?

1053