Finding the Simple Interest in sql

Bageshkumarbagi
Posted by Bageshkumarbagi under Sql Server category on | Points: 40 | Views : 1551
Hi,

DECLARE @rate int,@time int,@Amount int
SET @rate=14
SET @time=4
SET @Amount=10000
SELECT (@rate*@time*@Amount)/100 AS 'Simple Interest'

************OutPut******************
Simple Interest
5600

Comments or Responses

Login to post response