PostgreSQL Row Number

rownumber.sql

-- pemberian nomor baris
with t as (
  select '081011124' nim, 'IPKU1001' kode_mk, 'Agama' nama_mk, 'D' nilai union all
  select '081011124' nim, 'IPKU1101' kode_mk, 'Pancasila' nama_mk, 'C' nilai union all
  select '081011124' nim, 'IPKU2204' kode_mk, 'Pemrograman Java' nama_mk, 'B' nilai union all
  select '081011124' nim, 'IPKU1101' kode_mk, 'Pancasila' nama_mk, 'B' nilai 
)
select nim, kode_mk, nama_mk, nilai
, row_number() over(partition by kode_mk order by nilai) baris
from t

-- filter hanya row bernomor baris=1
with t as (
  select '081011124' nim, 'IPKU1001' kode_mk, 'Agama' nama_mk, 'D' nilai union all
  select '081011124' nim, 'IPKU1101' kode_mk, 'Pancasila' nama_mk, 'C' nilai union all
  select '081011124' nim, 'IPKU2204' kode_mk, 'Pemrograman Java' nama_mk, 'B' nilai union all
  select '081011124' nim, 'IPKU1101' kode_mk, 'Pancasila' nama_mk, 'B' nilai 
)
select nim, kode_mk, nama_mk, nilai 
from (
  select nim, kode_mk, nama_mk, nilai
  , row_number() over(partition by kode_mk order by nilai) baris
  from t
) tabel1
where baris=1