[PostgreSQL] PostgreSQL Numbering ROW_NUMBER()

---

We can number in postgreSQL on ROW_NUMBER();

 

 

 

Method

(ROW_NUMBER() OVER()),

 

 

 

example

		SELECT 
			(ROW_NUMBER() OVER()),
			A.MANAGE_CODE,
			A.ROAD_ADDRESS,
			A.LATITUDE,
			A.LONGITUDE,
			B.CDE_LAB
		FROM
			CMT_FCLTY_INF A
		LEFT JOIN MAN_SYS_CDE B ON A.FCLTY_TYPE_CODE = B.CDE_VAL
		ORDER BY MANAGE_CODE ASC

 

 

 

 

 

 

---

 

To be continued..