Search
 
SCRIPT & CODE EXAMPLE
 

SQL

second last highest id in sql

SELECT * FROM `salary` ORDER BY id DESC LIMIT 1,1;
Comment

PREVIOUS NEXT
Code Example
Sql :: get count by weekly pivot table sql server 
Sql :: sql server find all foreign keys that reference a column 
Sql :: python mysql select 
Sql :: mysql count lines 
Sql :: sql datetime as date 
Sql :: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" f 
Sql :: alter user root mysql 
Sql :: oracle next run dates 
Sql :: show structure of table in sql 
Sql :: postgresql format date dd/mm/yyyy 
Sql :: mysql calculate age 
Sql :: how to see logical reads in sql server 
Sql :: sql server delete row 
Sql :: mysql return text after a final full stop 
Sql :: drop procedure sql 
Sql :: error code 1292 mysql workbench 
Sql :: copy all values of a column to another column in sql in same table 
Sql :: how to check even or odd in sql 
Sql :: postgresql division count return 0 
Sql :: Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. 
Sql :: mysql extract month 
Sql :: select insert new table sql server 
Sql :: convert series number to date in sql 
Sql :: base nosql 
Sql :: v$session table or view does not exist 
Sql :: set auto increment to 1 mysql 
Sql :: ksql terminate all queries 
Sql :: alter table add column 
Sql :: MSSQL SYNTAX PROCEDURE FUNCTION TRIGGER 
Sql :: grant mysql 
ADD CONTENT
Topic
Content
Source link
Name
4+2 =