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 / barochia dharmesh

You should use rank query with order by and give where your
search criteria.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is replication id?

934


Name three sql operations that perform a sort.

1002


What is query execution plan in sql?

1185


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

989


Can we create index on primary key?

962


What is oracle sql developer?

1043


How do I kill a query in postgresql?

1110


what are the differences between binary and varbinary? : Sql dba

1038


What are sql objects?

1075


What are basic techniques of indexing?

1383


how would concatenate strings in mysql? : Sql dba

1090


How does a trigger work?

1064


What is error ora-12154: tns:could not resolve the connect identifier specified?

1072


Why do we use procedures in pl sql?

1035


how to rename an existing column in a table? : Sql dba

1016