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 salary?

Answer Posted / amruta dash

select max(salary) from tblname where salary not in (select
max(salary) from tblname);

Is This Answer Correct ?    23 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State a few properties of relational databases?

1182


1 01 101 01010

2101


Can I disable or restrict ssrs export formats (rendering formats)?

155


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1023


what are the Prerequisites for Replication?

11445


How do we know if any query is retrieving a large amount of data or very little data?

1034


How do I find the size of a sql server database?

982


what are constraints? Explain different types of constraints? : Sql server database administration

1050


What is 1nf 2nf and 3nf?

960


Which are the olap features?

1010


What do you mean by recursive stored procedure?

993


How to assign new column names in a view?

963


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

1000


How to modify an existing user defined function?

1171


What is the filtered index?

1110