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 primary and foreign key?

1124


How can I see all tables in sql?

1148


how to enter characters as hex numbers? : Sql dba

1104


how can we submit a form without a submit button? : Sql dba

1037


How many sql core licenses do I need?

998


What is varchar sql?

1207


How do I use google cloud in sql?

1148


When you have to use a default "rollback to" savepoint of plvlog?

1252


What is example of database?

1135


What is pessimistic concurrency control? : Transact sql

1136


What is procedure and function?

1035


What are joins in sql?

1110


Why having clause is used in sql?

1021


Can we use rowid as primary key?

1046


Explain the rollback statement?

1072