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 / praveen agrawal

select sal from employee order by sal desc limit 1,1;

its 100% true i have checked it out.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why commit is not used in triggers?

1038


What is a column in a table?

1118


How do I save a stored procedure?

1001


What is scalar data type in pl sql?

1066


What is difference between cursor and trigger?

1070


Does sql*plus also have a pl/sql engine?

1076


What does the file extension accdb stand for?

968


How do I create a sql script?

1096


how can we find the number of rows in a table using mysql? : Sql dba

1082


What is the best free sql database?

1049


Write the alter statement to enable all the triggers on the t.students table.

1123


What is trigger price?

983


How can triggers be used for the table auditing?

1066


what is clause? : Sql dba

1060


How do you explain an index number?

1097