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 get second highest salary in SQL(as/4000

Answer Posted / premchand

select max(sal) from employ where sal < select max(sal)
from employ

Is This Answer Correct ?    34 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1099


Why we use sql profiler?

963


Can I learn sql in a week?

1083


What is the use of index in hive?

1007


What is the file extension for sql database?

1009


What is your daily office routine?

2275


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

5171


how to use in conditions? : Sql dba

1017


How many columns should be in an index?

964


Explain isolation levels. : Transact sql

1075


Is sql harder than python?

1110


How can I speed up sql query?

968


What are the subsets of sql?

1139


How can we implement rollback or commit statement in a trigger?

1041


What does fetching a cursor do?

1096