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

CS1056 Unexpected character '\0' pada visual studio 2022

 apabila mengalami error CS1056 Unexpected  character '\0'

pada saat menjalankan program di visual studio 2022

hapus folder release pada sub directory aplikasi anda.

setelah itu dicompile lagi dan dijalankan 

membuat scala Visual Studio 100%

Select Tools > Command Line > Developer Command Promp

devenv /noScale

untuk membuat scala view 100%

membuat random di MsSQL - OTP

 SELECT CAST(RAND()*100000 AS INT) as otpRANDOM;