Discussion Forums

New User? Please read instructions!

Facing this issue for quite long, I would like experts to help me with it?  

  RSS

christin
New Member
Joined: 3 months  ago
Posts: 1
16/05/2017 5:46 pm  

I require or I would like to generate following output from the query:
--Hadid Automobile Loan 100 200 200 100
--Nahyan Automobile Loan 0 100 100 100 

I am using the following query and I would need help from professionals working in reputed software development companies so that I can get best examples of coding. The idea of getting help from professionals working in top firms is because it is a fact that experience teaches a lot of lessons and learning. There are a lot of things that an individual learns in practical life rather than school or college days. This is the reason that I am requesting experts and professionals to help me with it.

 

Create Table Workforce
(
EName varchar(20),
AmtType varchar(30),
Cash decimal(18,2),
AAmount decimal(18,2),
BAmount decimal(18,2),
CAmount decimal(18,2),
)

Insert into Workforce values('Hadid','Car Loan',100,0,0,0)
Insert into Workforce values('Hadid','Car Loan',0,100,0,0)
Insert into Workforce values('Hadid','Car Loan',0,0,100,0)
Insert into Workforce values('Hadid','Car Loan',0,0,0,100)

Insert into Workforce values('Nahyan','Car Loan',0,100,0,0)
Insert into Workforce values('Nahyan','Car Loan',0,0,100,0)
Insert into Workforce values('Nahyan','Car Loan',0,0,0,100)

Select * from Workforce

Edited: 3 months  ago

ReplyQuote
  
Working

Please Login or Register

1. Online Compilers - Compile & Run your C/C++ programs:

✅ Online Compilers

2. Ask your questions or clarify your/others doubts from,

✅ Online Discussion Forums by Fresh2Refresh.com





Share this website !!!
Facebook Twitter Linkedin

Close
We Support JALLIKATTU !!!
We Support JALLIKATTU!
By Fresh2Refresh.com
Show Your Support as well. Thanks!