sql Limit

Please login or create account to add a snippet.

Follow @TagMyCode

Language: SQL

Posted by: Lars Wichmann

Added: Feb 9, 2021 1:04 PM

Tags: limit performanc sql

//Example 1, gets the SECOND LAST VALUE AND NOT the LAST. IF there are deleted ROWS BETWEEN the ids they will note it AND make it RIGHT!
//FOR example LAST id IS 1700 AND secand LAST IS 1643 there are deleted ROWS AND Max-1 IS would WORK correct them
IF(empty($results33)){
$querry33 = 'SELECT id AS LastAfterCurrent, wassertemp, zeitTemp FROM riverwassertemp order by LastAfterCurrent DESC LIMIT 1,1';
$results33 = $wpdb->get_results($querry33);
}