Click here to Skip to main content
15,434,299 members
Home / Discussions / Database
   

Database

 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:05
MemberDeques18-Dec-07 2:05 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:10
MemberTobias Schoenig18-Dec-07 2:10 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:17
MemberDeques18-Dec-07 2:17 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:22
MemberTobias Schoenig18-Dec-07 2:22 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:31
MemberDeques18-Dec-07 2:31 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:32
MemberTobias Schoenig18-Dec-07 2:32 
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:43
MemberDeques18-Dec-07 2:43 
GeneralRe: select the max value from the row and its other values Pin
Tobias Schoenig18-Dec-07 2:49
MemberTobias Schoenig18-Dec-07 2:49 
This works for me:

SELECT g.Maximum, out_pumptable.posnumber from out_pumptable, (SELECT MAX(flow_lpm) as Maximum, posnumber FROM out_pumptable GROUP BY posnumber)g WHERE flow_lpm = g.Maximum group by g.Maximum, out_pumptable.posnumber
GeneralRe: select the max value from the row and its other values Pin
Deques18-Dec-07 2:53
MemberDeques18-Dec-07 2:53 
GeneralRe: select the max value from the row and its other values Pin
Rupert Todd19-Dec-07 9:36
MemberRupert Todd19-Dec-07 9:36 
Generalcalling a storedprocedure from a function in mysql Pin
sepel18-Dec-07 0:35
Membersepel18-Dec-07 0:35 
GeneralDatabase Timeout!!!! Pin
__yash__18-Dec-07 0:19
professional__yash__18-Dec-07 0:19 
GeneralRe: Database Timeout!!!! Pin
Pete O'Hanlon18-Dec-07 0:26
mvaPete O'Hanlon18-Dec-07 0:26 
GeneralRe: Database Timeout!!!! Pin
__yash__18-Dec-07 0:41
professional__yash__18-Dec-07 0:41 
GeneralRe: Database Timeout!!!! Pin
Pete O'Hanlon18-Dec-07 1:13
mvaPete O'Hanlon18-Dec-07 1:13 
GeneralRe: Database Timeout!!!! Pin
__yash__18-Dec-07 1:29
professional__yash__18-Dec-07 1:29 
QuestionRe: Database Timeout!!!! Pin
David Crow19-Dec-07 2:29
MemberDavid Crow19-Dec-07 2:29 
GeneralRe: Database Timeout!!!! Pin
__yash__20-Dec-07 0:39
professional__yash__20-Dec-07 0:39 
GeneralRe: Database Timeout!!!! Pin
David Crow20-Dec-07 2:22
MemberDavid Crow20-Dec-07 2:22 
Questionhow to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:02
MemberShimnaMukundan18-Dec-07 0:02 
AnswerRe: how to check the already existing data Pin
Pete O'Hanlon18-Dec-07 0:12
mvaPete O'Hanlon18-Dec-07 0:12 
GeneralRe: how to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:58
MemberShimnaMukundan18-Dec-07 0:58 
QuestionHow can I update databse record on application ending explicitly(power failure) Pin
Gokul Harsh17-Dec-07 22:42
MemberGokul Harsh17-Dec-07 22:42 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#17-Dec-07 23:03
MemberRocky#17-Dec-07 23:03 
AnswerRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon17-Dec-07 23:49
mvaPete O'Hanlon17-Dec-07 23:49 

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.