-
Select ITEM.ITEM_NAME,
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'CRASH',RESULT.AVG_VALUE)),
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'CRASH',RESULT.MIN_VALUE)),
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'CRASH',RESULT.MAX_VALUE)),
-
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'SPEED',RESULT.AVG_VALUE)),
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'SPEED',RESULT.MIN_VALUE)),
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'SPEED',RESULT.MAX_VALUE)) ,
-
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'BREAK',RESULT.AVG_VALUE)),
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'BREAK',RESULT.MIN_VALUE)),
-
Max(decode(ANALYSIS.ANALYSIS_NAME,'BREAK',RESULT.MAX_VALUE))
-
...
-
Max(...)
-
...
-
-
from ITEM, ANALYSIS, RESULT
-
where RESULT.ITEM_ID=ITEM.ITEM_ID
-
and RESULT.ANALYSIS_ID=ANALYSIS.ANALYSIS_ID
-
Group by ITEM.ITEM_NAME
-
1 2754 Luuk 1,047
Expert 1GB
What is the definition of MFTR_NAME ?
But some googling found this link, which claims it's an Oracle 10 bug...
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Tim Partridge |
last post by:
I have a std list of student objects and I would like to sort them by
providing a comparison function. I have gotten it to work if my function
is global, but I would like to encapsulate it in a...
|
by: Rafael Faria |
last post by:
Hello All,
I'm new to DB2, so apologies in advance for any stupid comments I
might make on this replication problem.
Using Information integrator and DB2 8.2 I managed to create a
nickname that...
|
by: Janick Bernet |
last post by:
Since DB2 V8 command center always displays the full error message. Not
only the SQL error number and some short specific information, but the
whole bunch of additional stuff which you find in the...
|
by: Michelle |
last post by:
Hi all
I have used knowledge base article 112747 to improve my subforms
performance. I am using Access 97.
I have a main form where i put an extra textbox which concatenated
TeamID WeekNum...
|
by: Rajat Katyal |
last post by:
Hi:
Whenever i try to insert the data, size of which is greater than that of column datatype size, I got the exception value too long for.....
However this was not in postgresql7.2.
Can...
|
by: mohitp |
last post by:
HI
I am trying to compile WSDLs on a unix box, it generates the .obj file, but when creating .lib it throws this error
execvp: ar: Arg list too long
Any pointers to this error?
Thanks
Mohit
|
by: babukgl |
last post by:
Hi,
We have a stored procedure which does a huge amount of
transformation of data and it is running pretty slow. To avoid this we
tried to create a cursor out of the SQL used in stored...
|
by: Moqtar |
last post by:
I am trying to walk a directory and print the file and its modified
time. When the path is longer then 259 characters i get an error
"Filename too long". I guess these is because windows limitation...
|
by: Ron |
last post by:
I am getting an error Option strict on disallows implicit conversion
from string to long
I get it for this code
iStartPosition = InStr(iStartPosition + 1, RichTextBox1.Text, "A" Or
"a"
the...
|
by: rahulae |
last post by:
help me with this, i need to sort the order to be like sun,mon,tue,wed,thu,fri,sat
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |