I’ve got a big problem with this complicated SQL. Could anyone give me a hand?
My first aim(not the final goal) is:fliter the duplicate data with query statment( select not delete) , that is, the various entries of EndTime and Qos for a same ServiceID due to the repeated feedback. The rule is to only keep the records with the lowest Qos for a same ServiceID. If there are several records having the lowest Qos, then only keep whatever...
3 results in 0.0062 seconds.
-
bbaaking started a topic How to filtrate duplicate data about technical support and compute rank of orderin MySQLHow to filtrate duplicate data about technical support and compute rank of order
Last edited by bbaaking; Apr 18 '12, 08:03 AM. Reason: aim 1 had solved, I make it clear, and find help about aim2 ,3,and 4(my final goal) -
thierry savard started a topic Is it possible to cast the return value of a compute avg(X value) to show 4 decimal?in SQL ServerIs it possible to cast the return value of a compute avg(X value) to show 4 decimal?
I want the 2 compute column to show only 4 decimal, but I cant find a way to affect the return value of 'em.
I wrote down this command "compute avg(x)" because I need the average to be in a seperate table.
When you use compute avg(x) here x is cast (price as decimal(10,4)) because I need the price to show up in the main table, and I need it with 4 decimals.
So I need a way to cast the return...Last edited by Niheel; Jan 26 '11, 08:14 PM. -
Compute and Merge columns in array
Hello
Here is my issue
I have a two dimensions array that looks like this:
EMPTY, Type1, Type2, Type3, Type4
Choice1, Value11, Value 12, Value 13, Value 14
Choice2, Value21, Value 22, Value 23, Value 24
Choice3, Value31, Value 32, Value 33, Value 34
I am being posted a value from another page which looks like this
dim mergeAndCompute :mergeAndComput e="ColumnName:T ype1,Type3"...
