我有一个表,其中包含ID、CW_savings、PW_Savings和Savings_Diff(CW-PW)。我想根据和(Savings_Diff)对表进行排序,如果它是>=0,那么Desc(最先显示的是最大的正向差),否则是asc(最先显示的是最大的-ve差)。目前我使用的是:from table when sum(savi
First Name], Savings.savingIdAS [Savings Id], Savings.enteredAmount AS [Amount] LEFT JOIN Savings ON Member.memberID= Savings.memberId
WHERE Member.isA
ParadiseInfo2 public static void main(String[] args) double price; double savingsSystem.out.println("Discount of " + discount + " percent");
System.out.println("That's a savingsof at least $" + savings