Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Fff
declare @nome varchar(80), @vlr_salario_fixo float, @vlr_comissao float; declare @vlr_total_vendas float, @vlr_salario_total float; set @nome = 'Cesar'; set @vlr_salario_fixo = 1500; set @vlr_total_vendas = 5000; set @vlr_comissao = @vlr_total_vendas * 15 / 100; set @vlr_salario_total = @vlr_salario_fixo + @vlr_comissao; print 'Nome do Vendedor ' + @nome; print 'Salario Fixo ' + cast(@vlr_salario_fixo as varchar); print 'Total Vendas ' + cast(@vlr_total_vendas as varchar); print 'Salario Total ' + cast(@vlr_salario_total as varchar);
run
|
edit
|
history
|
help
0
Rno 37 boat
SQL_RankingFunctions
mc170400712
Exam
How to find 2nd highest salary
RBT QA
Preppin Data Challenge - Week 9
Manish_SQL_11_dec
TABLE
20181CSE0068