Click here to Skip to main content
15,846,899 members
Home / Discussions / Database
   

Database

 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:41
Tobias Schoenig18-Dec-07 2:41 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:51
Deques18-Dec-07 2:51 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:59
Tobias Schoenig18-Dec-07 2:59 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 3:05
Deques18-Dec-07 3:05 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 3:10
Tobias Schoenig18-Dec-07 3:10 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 3:17
Deques18-Dec-07 3:17 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 3:22
Tobias Schoenig18-Dec-07 3:22 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 3:31
Deques18-Dec-07 3:31 
top 1 seems not be working good for this

I get this result, (partially), from the query you gave me
3320,9	P110101        
3320,9	P110101        
3220	P110102        
3220	P110102        
529,14	P110301        
3706,2	P111501        


P110102 got two rows, how do i get one of it only?
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 3:32
Tobias Schoenig18-Dec-07 3:32 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 3:43
Deques18-Dec-07 3:43 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 3:49
Tobias Schoenig18-Dec-07 3:49 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 3:53
Deques18-Dec-07 3:53 
GeneralRe: select the max value from the row and its other values Pin
Rupert Todd19-Dec-07 10:36
Rupert Todd19-Dec-07 10:36 
Generalcalling a storedprocedure from a function in mysql Pin
sepel18-Dec-07 1:35
sepel18-Dec-07 1:35 
GeneralDatabase Timeout!!!! Pin
__yash__18-Dec-07 1:19
professional__yash__18-Dec-07 1:19 
GeneralRe: Database Timeout!!!! Pin
Pete O'Hanlon18-Dec-07 1:26
subeditorPete O'Hanlon18-Dec-07 1:26 
GeneralRe: Database Timeout!!!! Pin
__yash__18-Dec-07 1:41
professional__yash__18-Dec-07 1:41 
GeneralRe: Database Timeout!!!! Pin
Pete O'Hanlon18-Dec-07 2:13
subeditorPete O'Hanlon18-Dec-07 2:13 
GeneralRe: Database Timeout!!!! Pin
__yash__18-Dec-07 2:29
professional__yash__18-Dec-07 2:29 
QuestionRe: Database Timeout!!!! Pin
David Crow19-Dec-07 3:29
David Crow19-Dec-07 3:29 
GeneralRe: Database Timeout!!!! Pin
__yash__20-Dec-07 1:39
professional__yash__20-Dec-07 1:39 
GeneralRe: Database Timeout!!!! Pin
David Crow20-Dec-07 3:22
David Crow20-Dec-07 3:22 
Questionhow to check the already existing data Pin
ShimnaMukundan18-Dec-07 1:02
ShimnaMukundan18-Dec-07 1:02 
AnswerRe: how to check the already existing data Pin
Pete O'Hanlon18-Dec-07 1:12
subeditorPete O'Hanlon18-Dec-07 1:12 
GeneralRe: how to check the already existing data Pin
ShimnaMukundan18-Dec-07 1:58
ShimnaMukundan18-Dec-07 1:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.