How to select second last row from table?

Table Name :- ModelParam_EMS

Primary Key :- ParameterID

No of Rows :- 500

want to select 499th row from table only.

Note :- No. of rows can be less or more but not fixed.

Create Table :-

``
CREATE TABLE modelparam_ems (
MakerModelID smallint(5) unsigned NOT NULL,
ParameterID smallint(5) unsigned NOT NULL AUTO_INCREMENT,
Category tinyint(3) NOT NULL DEFAULT '1',
ParameterName varchar(50) NOT NULL,
ParameterAdd smallint(5) NOT NULL,
ParamterType tinyint(3) unsigned NOT NULL,
DataTypeIndex tinyint(3) unsigned NOT NULL,
DefaultResolutionIndex tinyint(3) unsigned NOT NULL,
ParamUnit varchar(20) NOT NULL,
ParamMaxVal varchar(40) NOT NULL,
ParamMinVal varchar(40) NOT NULL,
ParamVal varchar(40) NOT NULL,
CreatedByID smallint(5) unsigned DEFAULT NULL,
CreatedOn datetime DEFAULT NULL,
ModifyById smallint(5) unsigned DEFAULT NULL,
ModifyOn datetime DEFAULT NULL,
chanelno int(11) DEFAULT NULL,
PRIMARY KEY (ParameterID),
KEY MkrMdlId (MakerModelID),
KEY DTIndex (DataTypeIndex),
KEY ResIndex (DefaultResolutionIndex),
KEY CrtByID (CreatedByID),
KEY ModfyById (ModifyById),
KEY paramTp (ParamterType),
KEY Categor (Category),
KEY idx_modelparam_ems_parameterid (ParameterID),
CONSTRAINT Category FOREIGN KEY (Category) REFERENCES category_ems (categoryid) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT m2m3 FOREIGN KEY (MakerModelID) REFERENCES makermodel_ems (MakerModelID) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT modelparam_ems_ibfk_1 FOREIGN KEY (CreatedByID) REFERENCES userlogi

You can use this:

SELECT *
FROM table_name
ORDER BY column_name DESC
LIMIT n - 1, 1

The query just returns the first row after n-1 row(s)

For example, if you want to get the second most expensive product (n = 2) in the products table, you just use the following query:

SELECT productCode, productName, buyPrice
FROM products 
ORDER BY buyPrice desc 
LIMIT 1, 1

Try this. Could test here and it's ok.

Found this site helpfull

StackExchange Database Administrators Q#104560, answer score: 6