[postgresql] rownumber

조회할 쿼리

SELECT
  sno 
  , sname 
  , year 
  , dept 
FROM student

 

rownum 사용 

SELECT
  (ROW_NUMBER() OVER()) AS rownum
  , sno 
  , sname 
  , year 
  , dept 
FROM student