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

select *from emp where sal<selct *from emp where<select *from emp

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are field types?

1000


What is a memo field?

967


What is anonymous block in sql?

1120


What are all the different normalization?

1037


What is the purpose of the partition table?

1049


what are all types of user defined functions? : Sql dba

1042


What are the advantages of pl sql over sql?

1025


How does cross join work?

949


How do rank () and dense_rank () differ?

1044


Can we call procedure in select statement?

1053


What is sequence in sql?

999


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

970


What is sql*loader and what is it used for? : aql loader

1172


Define join and name different types of joins?

1006


What is column?

987