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

Database

 
GeneralRe: select the max value from the row and its other values Pin
Rupert Todd19-Dec-07 9:36
Rupert Todd19-Dec-07 9:36 
I believe you need to join the table to a subset of itself.

You create a subquery that gives you the values of project and the highest col1 and attribute that to a temptable. You then join you orignal table to your temp table on the values of col1. This should do the trick!

SELECT PT.* FROM out_pumptable PT join
(select project, max(col1) as MaxVal from out_pumptable group by project) TEMPTABLE1 on TEMPTABLE1.MaxVal = PT.col1
Generalcalling a storedprocedure from a function in mysql Pin
sepel18-Dec-07 0:35
sepel18-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
mvePete 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
mvePete 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
David 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
David Crow20-Dec-07 2:22 
Questionhow to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:02
ShimnaMukundan18-Dec-07 0:02 
AnswerRe: how to check the already existing data Pin
Pete O'Hanlon18-Dec-07 0:12
mvePete O'Hanlon18-Dec-07 0:12 
GeneralRe: how to check the already existing data Pin
ShimnaMukundan18-Dec-07 0:58
ShimnaMukundan18-Dec-07 0:58 
QuestionHow can I update databse record on application ending explicitly(power failure) Pin
Gokul Harsh17-Dec-07 22:42
Gokul 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
Rocky#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
mvePete O'Hanlon17-Dec-07 23:49 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Rocky#18-Dec-07 0:30
Rocky#18-Dec-07 0:30 
GeneralRe: How can I update databse record on application ending explicitly(power failure) Pin
Pete O'Hanlon18-Dec-07 1:16
mvePete O'Hanlon18-Dec-07 1:16 
GeneralSql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov17-Dec-07 19:58
kssknov17-Dec-07 19:58 
GeneralRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
That's Aragon17-Dec-07 21:46
That's Aragon17-Dec-07 21:46 
QuestionRe: Sql2005: How to get the error msg thrown from Storedproc to C# class Pin
kssknov18-Dec-07 21:02
kssknov18-Dec-07 21:02 
GeneralProblem in writing a stored procedure in SQL SERVER 2000 Pin
Member 305788717-Dec-07 19:41
Member 305788717-Dec-07 19:41 
GeneralRe: Problem in writing a stored procedure in SQL SERVER 2000 Pin
pmarfleet17-Dec-07 21:41
pmarfleet17-Dec-07 21:41 
GeneralQuery regarding SQL Pin
sandhya1417-Dec-07 18:45
sandhya1417-Dec-07 18:45 
GeneralRe: Query regarding SQL Pin
That's Aragon17-Dec-07 18:52
That's Aragon17-Dec-07 18:52 

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.