sp_6.sql

use tempdb
go

-- membuat functions

CREATE FUNCTION dbo.salesOrderTerakhir(@nilai_terakhir int = 5)
returns table
as
	return (
		select * from (
			select  row_number() over (order by salesOrderId Desc ) as nomor, *
			from AdventureWorks2012.sales.SalesOrderHeader
		) a where nomor <= @nilai_terakhir
	);
go

-- menjalankan stored procedure dan melihat hasilnya

select * from dbo.salesOrderTerakhir(10)

-- menghapus


DROP function [dbo].[salesOrderTerakhir]