Discussion Forums

New User? Please read instructions!

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


New Member
Joined:2 years  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



  1. C program for prime number
  2. C program for factorial
  3. C program for fibonacci series
  4. C program for palindrome
  5. C program for swapping 2 numbers with and without temp variables
  6. C program to find leap year
  7. C program to find armstrong number
  8. C program to find simple and compound interest
  9. C program to find largest of given 3 numbers
  10. C program to find smallest of given 3 numbers
  11. C program to convert lower case into upper case and vice versa
  12. C program to find sum and average of given 3 numbers
  13. C program to sum up all individual digits
  14. C program to reverse given number
  15. C program to reverse given string
  16. C program to find strong number
  17. C program to find square and cube of given number
  18. C program to print hello world without using semi colon
  19. C program to sort given names in alphabetical order
  20. C program to copy content of one file to another
  21. C program to sort given numbers in ascending order
  22. C program to sort given numbers in descending order
  23. C program to search given number in an array
  24. C program for recursive function
  25. C program for calculator application
  26. C program for bank application
  27. C program to check given number is perfect number or not
  28. C program to find array size
  29. C program to find whether given character vowel or not
  30. C program to check whether given number is positive or negative
  31. C program to find sum of n numbers
  32. C program to compare 2 numbers without if statement
  33. C program to generate random numbers
  34. C program to compare 2 arrays whether they are equal or not
  35. C program to print number from 1 to 500 without using any loop conditions
  36. C program to insert an element into an array
  37. C program to delete an element from an array
  38. C program to find hcf (gcd) and lcm
  39. C program to print diamond pattern
  40. C program to print pascal triangle
  41. C program to add two complex numbers
  42. C program for binary search
  43. C program for linear search
  44. C program for matrix addition
  45. C program for matrix multiplication
  46. C program for bubble sort
  47. C program for insertion sort
  48. C program for selection sort

Share this website !!!
Facebook Twitter Linkedin


Please Login or Register