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 pl/sql table? Why is it used?

1014


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1042


What are the different tcl commands in sql?

1151


What is pl sql and why it is used for?

1099


Whis is not false in primary key?

1443


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

1017


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2007


What is the location of pre_defined_functions.

1151


What does varchar include?

935


How do you modify a table in sql?

1107


what are enums used for in mysql? : Sql dba

1157


What is the starting oracle error number?

1037


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1123


How delete all data from all tables in sql?

932


What is cte sql?

972