Sql

Search

postgresql find missing id

SELECT all_ids AS missing_ids
FROM generate_series((SELECT MIN(id) FROM your_table), (SELECT MAX(id) FROM your_table)) all_ids
EXCEPT 
SELECT id FROM your_table

Comment

PREVIOUS	NEXT

Code Example
Sql :: how to rename column name in sql server using query
Sql :: copy data from one postgres container to another
Sql :: how to do an average on a count sql
Sql :: show database not empty tables postgres
Sql :: update field in sql to null
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Sql :: windows aggregate functions in postgresql
Sql :: cara menampilkan user di mysql terminal
Sql :: sql order of execution
Sql :: mysql order by rand limit 1 really slow
Sql :: sqlalchemy query sql compiled
Sql :: create fulltext index mysql
Sql :: oracle create or replace index
Sql :: oracle merge insert if not exists
Sql :: sql order by except one row
Sql :: mysqldump password in file
Sql :: how to insert same table data using mysql query
Sql :: not equal in mysql query
Sql :: drop procedure postgres
Sql :: how to put 0 or 000 depending IDCustomer length in sql server
Sql :: WHERE value IS sql
Sql :: what does leave do in mysql
Sql :: sql round datetime
Sql :: postgresql fastapi sqlmodel example
Sql :: data types mysql vs postgresql
Sql :: t sql return on letters only
Sql :: can sqldatareader be null
Sql :: sql datetime functions
Sql :: Sql Text or Varchar
Sql :: oracle insert multiple rows into same table

Search

SQL

postgresql find missing id

ADD CONTENT