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 retrive only second row from table?

Answer Posted / sudip chatterjee

If the table is salary.then
SELECT * FROM salary ORDER BY income DESC LIMIT 1, 1;
here income is one attribute of salary table......
just use it.

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 the non-clustered index in sql?

1058


Why is sql*loader direct path so fast?

1100


how to select unique records from a table? : Sql dba

1111


What is sql and its types?

1180


what is recursive stored procedure? : Sql dba

984


What are the parts of a basic sql query?

966


Is sql database free?

971


What is a mutating table and a constraining table?

1107


How do I view output in sql developer?

1082


Why do we need pl sql?

972


what is foreign key? : Sql dba

1030


Is oracel sql developer written in java?

1101


How do I truncate a word?

1087


What is sql catalog?

1014


what is the difference between blob and text? : Sql dba

1017