The Big Programming Thread - Page 457

select distinct OperatorKey, ID, DateLoaded from DimOperator order by DateLoaded desc

select MIN(OperatorKey) AS OperatorKey, DateLoaded
from DimOperator
group by OperatorKey, DateLoaded
order by DateLoaded desc

On March 20 2014 17:34 unkkz wrote:
Damn i suck at SQL. Anyone that can help me out with this query?

In the table DimOperator, i want non duplicate values of the column OperatorKey. Included in the results i need the DateLoaded column and the ID column. The values in ID and DateLoaded have no possibility of being a duplicate so i need only to display them so i can cross reference with another database. The problem is that i need a count of the column OperatorKey without duplicate values. I have tried this in two steps, aka getting no duplicates at first and then working a count in there(i'm a newb)

Here's what i have tried so far:

select distinct OperatorKey, ID, DateLoaded from DimOperator order by DateLoaded desc

- Does not return unique OperatorKey, returns several of the same value.

select MIN(OperatorKey) AS OperatorKey, DateLoaded
from DimOperator
group by OperatorKey, DateLoaded
order by DateLoaded desc

- Same problem as above, it does not return unique OperatorKey's. I have no real reasoning for trying these other then based on similar google examples.

This would be my failed attempts at the first step, however if someone can manage a count on the column OperatorKey that does not include duplicate values that'd be super as well. If there's an explanation to the query as well then i might just be in heaven...

Results i get:

Operator Key DateLoaded ID
402 2013-xx 8052
402 2013-xx 8053
403 2013-xx 8054

Results i want:
402 2013-xx 8052
403 2013-xx 8054
etc

select * from DimOperator join 
      ( select OperatorKey, min(ID) as minid, count(oper) as counter 
        from DimOperator group by OperatorKey ) ss 
     on ( DimOperator.ID = ss.minid )

select OperatorKey, min(ID) as minid, count(OperatorKey) as counter from DimOperator 
group by OperatorKey

On March 20 2014 17:34 unkkz wrote:
Damn i suck at SQL. Anyone that can help me out with this query?

In the table DimOperator, i want non duplicate values of the column OperatorKey. Included in the results i need the DateLoaded column and the ID column. The values in ID and DateLoaded have no possibility of being a duplicate so i need only to display them so i can cross reference with another database. The problem is that i need a count of the column OperatorKey without duplicate values. I have tried this in two steps, aka getting no duplicates at first and then working a count in there(i'm a newb)

Here's what i have tried so far:

select distinct OperatorKey, ID, DateLoaded from DimOperator order by DateLoaded desc

- Does not return unique OperatorKey, returns several of the same value.

select MIN(OperatorKey) AS OperatorKey, DateLoaded
from DimOperator
group by OperatorKey, DateLoaded
order by DateLoaded desc

- Same problem as above, it does not return unique OperatorKey's. I have no real reasoning for trying these other then based on similar google examples.

This would be my failed attempts at the first step, however if someone can manage a count on the column OperatorKey that does not include duplicate values that'd be super as well. If there's an explanation to the query as well then i might just be in heaven...

Results i get:

Operator Key DateLoaded ID
402 2013-xx 8052
402 2013-xx 8053
403 2013-xx 8054

Results i want:
402 2013-xx 8052
403 2013-xx 8054
etc

SELECT DISTINCT OperatorKey FROM ...

SELECT OperatorKey, MIN(DateLoaded), MIN(ID) FROM ... GROUP BY OperatorKey

SELECT COUNT(DISTINCT OperatorKey) FROM ...

string[] lines = File.ReadAllLines (@"path\to\file");

string[] lines = File.ReadAllLines (@"path\to\file", Encoding.GetEncoding (1252));

var numArgs int = len(os.Args)
	var numThreads int = strconv.Atoi(os.Args[1])
   	fmt.Println(numThreads)

package PortfolioMaps;

import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;
import java.util.Objects;


class Investment implements Comparable<Investment>{ 
 private String ticker; // unique string identifier for stocks 
 private int numShares; 
 private double price; 
 


 public boolean equals( Object rhs ){
     return false;
 }


 public int compareTo( Investment rhs ){
     return 0;
 }
 

 class Portfolio implements Comparable<Portfolio> { 
 private String protfolioId; 
 private double cashBalance; 
 private List<Investment> holdings = new LinkedList<>(); 
 
 @Override
 public int compareTo(Portfolio obj){
     return 0;
 }
} 
 
// All the portfolios owned by a single customer 

 class Account implements Comparable<Account>, Iterable<Portfolio> { 
 private String accountId; 
 private List <Portfolio> portfolios; 
 
@Override
public int compareTo(Account obj){
     return 0;
 }
 void addPortfolio( Portfolio obj2 ){
     
 };

 public Iterator<Portfolio> iterator(){
     
 }
}
}

double totalPrice = numShares*price;

 public int compareTo( Investment rhs ){
     /* Find out this objects total price*/
    double thisTotalPrice = this.numShares*this.price;

    /* Find out rhs total price */
    double rhsTotalPrice = rhs.numShares*rhs.price;

   /* Return the difference (this - rhs)*/
    return thisTotalPrice - rhsTotalPrice;
 }

ArrayList<Investment> investments = new ArrayList<Investment>();
/* ... Fill ArrayList ...*/
Collections.sort(investments);