select row number pada postgresql

 select * from 

(

SELECT nim,count(*) as jml,ROW_NUMBER () OVER (ORDER BY npm) as no FROM public.data where periode='123' group by nim

) a 

 where a.no>=100 and a.no<=150

401 - Unauthorized: Access is denied due to invalid credentials.

 

401 - Unauthorized: Access is denied due to invalid credentials.

pada iis

1. silahkan jalankan IIS

2. site, nama site

3. Klik Authentication

4. Edit pada Anonymous Authentication, menjadi enabled, masukan user dan password

selesai