Answers for "postgresql sequence max value"

SQL
1

postgres set sequence value to max id

SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));
Posted by: Guest on January-19-2021
3

postgres select max value

SELECT * FROM payment
WHERE amount = (
 	SELECT
  	   MAX(amount)
	FROM
	   payment
);
Posted by: Guest on July-15-2020
0

setval max id postgresql sequence

SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));
Posted by: Guest on June-16-2021

Code answers related to "postgresql sequence max value"

Code answers related to "SQL"

Browse Popular Code Answers by Language