php - How do I select the highest column value in an SQL query IF another column is equal to a certain string -

-

I am trying to set up a matching system that chooses the highest value of two separate questions. I have seen other answers on the site and they do not help, I want to compare it originally:

I want to get the highest value from the version column where < Code> type is equal to, for example "code> type1 ". I want to get the highest value from the version column, where is of type is equal to " type2 ". I want to compare these files with PHP and find out that type2 's version to type1 ' s version < More than / code>. Is there any way I can do that?

Edit: Brian Dimilia has answered this question. Has a moderator answered it?

I believe this will do the job you want: 

  Select the version, type from tbl, where version = (maximum) (from tbl) select where type ('type1', 'type2'))

Type Result column will show 'type1' if maximum (version) was associated with a type 1 record, or 'Type 2' if maximum (version) was connected to a type 2 record.

If you want to know the highest version for Type 1 and the highest version for Type 2 (as you want values ​​returned to the output), and identify which high Is, you can use the following: 

  select type 1_max_version, T2. As the case type 2_max_version, case when t1.version & gt; T2.version then t1.version else t2.version end_machine_num as the end, when t1.version> T2.version then connect to tbl t1 as 'type1' else 'type2' end as the highest_version_type, join tbl t2, where t1.version = (select max from tbl) where type = 'type1') and t2 Version = (Select from maximum Tbl where type = 'type2')

Depending on your comment, if you want to filter on rows where there were some values ​​of field called "URIs" , You can use it following. It also assumes that you want to apply this filter for both Type 1 and Type 2 line. I know that this is not the case. In addition, if you want to make additional fields in the WHEEE clause, you will have to add them to the join clause between T1 and T2, otherwise you will need to repeat twice and repeat once again in the WHERE clause. Choose T1 for T2 

  Type 1_max_version as type, t2.version as type2_max_version, case when t1.version & gt; T2.version then t1.version else t2.version end_machine_num as the end, when t1.version> T2.version Then to connect 'firewall' and 'FBIpace' to TBL T1, TBL is T1 as the highest version of T2.usrips = t2.usrips, where t1.version = (TB to max (version ) Select where type = 'firewall' and 'URI'% 1.1.1.1% ') and T.Warson = (select maximum (version) from TB where type =' FBIpass' and '% 1.1.1.1%' Like URIs) and T1. '% 1.1.1.1%', such as spirits.

See Bela:


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

c# - Create dynamic LINQ query expression at runtime which translates into a parameterized SQL query for nullable types -

-
This question is related to my I want to make my custom expression for IQueryable in a nutshell. To achieve this goal, I wrote the next code. Public stable IQueryable & lt; T & gt; Filter Aquales & lt; T, TLL & gt; (This IQueryable & lt; T & gt; qSource, expression & lt; Func & lt; t; TLL; Field, TV value) {var fieldFilter = ExpressionClosureFactory.GetField (value); Var constraint = expression. Aqual (field. Body, field filter); Apply Return (qSource, Obstacle, Zone. Parameter); } Private Stable IQueryable & lt; T & gt; Apply & lt; T & gt; (IQueryable & lt; T & gt; qSource, Expression Barrier, ReadOnlyCollection & lt; Parameter Exposure & gt; Parameter) {var predicateFrom = Expression Lambda & lt; Func & lt; T, bool & gt; & Gt; (Hurdle, parameter); Return qSource.Where (predicateFrom); } Public Speaking Expression Clausfactree {Public Status Member Expert Gatefield & lt; TVLUE & gt; (TV va...
Read more

cmake - cpack generates RPMs with %files entries that conflict with the RPM spec. How to fix? -

-
Recently, I need to make sure that using our software by using cpack RHEL 7 and it can be packaged for free reconstruction (such as CentOS 7). Despite this, I have had a problem which was not present for RHEL 6.x and its free rebuilding: RPM, which has its % files cpack System entries such as the following are generated: % dir% attr (0755, root, root) "/"% dir% attr (0755, root, root) "/ usr"% Dir% attr (0755, root, root) "/ usr / bin"% dir% attr (0755, root, root) "/ usr / share"% dir% attr (0755, root, root) "/ usr / share / Applications "% dir% atr (0755, root, root)" / usr / share / doc "% dir% attr (0755, root, root)" / usr / share / icons "% di "/ Usr / share / icons / hicolor" / dir / hicolor "/ usr / users / share / icon / hicolor / scalable"% dir% attr (0755, root, root) Enter the% dir% plus (0755, root, root) "/ scalable / app" code which should not be declared by ...
Read more