oracle - Joining two case statements -

-

I would like to check that it is possible to combine the two statements together? I have tried to do something like this, but I am getting the 'Consumption bill illegal identifier' error. I know I get this error as I do not have a ConsumptionBill feature.

So it is still possible to get involved in two case statements? 

  Select CustName, preRead, newRead, new read-prearride at content consensus, case when prompt - sent date & gt; 30 THEN Consumption + FP when SYSDATE - Sent & gt; 45 THEN Consumption + AP ELSE ExpenditureBill + 0 from the BIll as Selection (Select C.firstName || '' .lastname as CostName, R.Newering PURED, Lead (RNU) Readings) over (R. electrascimetide ord by part arbitrage) as new read, BFS, FR as BSXRAT SR, TR as BHDRCTR, P. FastPanMT as FP, P As a SCPANAM SP, Blow .tent date, case new read-premiere = 20 then (newRead-preRead) * FR when newRead-preRead & lt; = 30 then 20 * FR (newRead-preRead -100) * SR when newRead-preRead & Gt; 40 then 20 * FR + 30 * SR + ((newRead- previousRead) -50) * TR reading r, svcaddress s, electricmeter w, customer c, rate a, nonresrate b, penRate p, bill from bill As the end of consumption, where W.electricmeterID = S.electricmeterID and R.electricmeterID = W.electricmeterID and Aetrad = SRTID and BRTID = Erratrad and C.customerID = S.customerID and C.customerID = bl.customerID and R.readingID = bl.readingID and P.preRateID = C.preRateID and C.customerType = 'nonr Esidential 'and r.datevisited & gt; = TO_DATE ('01 -05-2013 ',' DD-MM-YYYY ') and RDTivate and Lieutenant; TO_DATE ('31 -08-2013 ',' DD-MM-YYYY ')) where the new read is not empty;  
 
 It is difficult to tell without reference to what you are doing. 
 
 However, you probably want a subtitle 
 
 select  when SYSDATE - sentDate> 30 Consumption Bills + FP; When SYSDATE - Sent & gt; 45 then consumption bill + SP ELSE consumption + 0 EDD as total bond (Select FP, sent, SP, case when new read-prepper read <100 = THEN (new read-preoperated) * FR when new read-EDR Reid & lt; = 200 THEN 100 * FR (newRead-previousRead-100) * SR when newRead-previousRead> 200 then 100 * FR + 100 * SR + ((newRead-previousRead) -200) My_table from ConsumptionBill In the form of TR * end * T  
 
 Here, we also include an intermediate record  T  that the computed field  Consumpti OnBill  We want to use later. 
 
 (I call "intermediate", but only perceptual ... whether or not the query planner can set intermediate records - maybe this will not happen.)

Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

java - Gradle dependencies: compile project by relative path -

-
Is it possible to specify a dependency on another gradeal project in the granular (in android studios) outside the current project limits? For example, with a relative path like this: dependence {collection project ('../../ stdlib / dagger'}} MyApp (path / user / foo / workspace / mypad) The app (Path / User / Foo / Workspace / MyPass / App) And I have an Android Library Project with 3 subdomules: stdlib (path is / user / foo / Utilities (Path / User / Foo / Workspace / Stadlib / Utilis) http (Path / User / Foo / Workspace / Stadlib / HT) / Li> What I have to do is compile the Dagger, Util, http module in the MyApp project. The Stidelib Library module under heavy development And MyApp will grow in the form of Growth, so I do not want to push them into a Mewen repository. I am a little change. is likely to add another Gredle projects in some way? I will push the study library into the Maven repository after the source is in search of a temp...
Read more

ruby on rails - Object doesn't support #inspect when used with .include -

-
So I have participated in a glitch error that I do not even know how to debug. I am very new to the railing, so it has kicked my ass well when I use the .includes (school) seen by the student, it gives a blue box error, But when I look at any other model and .includes (school) , the school works just fine. class student & lt; ActiveRecord :: Base has has_many: relationships, foreign_key: "liker_id", dependent :: has_many: matches, foreign_key: "student_1_id", dependent :: deleted belong_to: school belong_to: conference belong_to: would_you_rather belong_to: home city belong_to: year is_to: Major and class school & lt; on the console activatecord :: Affiliate for the base: conference includes: respondent, class: "school", foreign_key: "rival_id" (e.g. For: School) Select SQL generated Select "School". * "School" from "school" "ID" IN (1) error message back NoMethodError: u...
Read more