need cash amount separate and cheque separate

Question

Dear sir need cash amount separate column cheque amount seperate please help me any one

Gnanavel Sekar · Answer

1.here can get sum of amount by cheque and cash select sum(Red_Received_amount)Red_type from Received_Details group by Red_Type 2.another way select * from Received_Details where Red_type='CASH' select * from Received_Details where Red_type='CHEQUE'

Nitin Sontakke · Answer

Try following: select Red_iid Red_Invoice_no case when Red_Type = 'CASH' then Red_received_Amount else 0 end Red_Received_Amount_Cash case when Red_Type = 'CHEQUE' then Red_received_Amount else 0 end Red_Received_Amount_Cheque -- Add more columns here... from dbo.Received_Details -- Add where clause here... Hope it helps!