Search the Community

Sql Query: I need to compare data for 2 dates while using GROUP BY <InvDate> results in multiple rows like Row1 - InvDate1 | Sum(Data Col1) | Row2 - InvDate2 | Sum(Data Col1) | But I need like Row1 - Sum(Data Col1) for InvDate1 | Sum(Data Col1) for InvDate2 Kindly help resolving it! Thanks! Jenender

Hi, I am not sure how to write a query for the below case, Pls help me out. ID description values M1 ab1 23 M1 ab2 54 M1 ab3 23 M2 ab1 67 M2 ab2 56 M2 ab3 91 M3 ab1 41 M3 ab2 53 M3 ab3 27 M3 ab4 41 Conditions: I need to pick the row when values are same for different description under similar ID, Example: Under ID (M1) , I have the description (ab1 and ab3) have same values (23), Similarly ID (M3) have same values 41 for descripttion ab1 and ab4. hence the result must be only Red texted in the table. Thanks In advance.

Hi, Need help in code trying to find employees old positon number but the job table gives current row position number since the employee was rehired. Please help.

PLEASE HELP IN A QUERY. i AM TRYING TO DO SELF JOIN WITH A QUERY WHICH 2 OR MOR ELEFT OUTER JOINS IN IT. HOW TO DO SELF JOIN HERE . THANKS IN ADVANCE.

RcptNo Discoount ProductCode Price 111 10 1122 1000 111 10 1123 1500 111 10 1124 2000 123 20 1123 2000 124 30 1125 1000 124 30 1120 2000 I want This Result Rcpt No:111 Discount :10 TOT price :1000+1500+2000-10=------; By Which Query This Result can be Obtained