Click here to Skip to main content
   

Database

 
GeneralRe: Select All Months and related data PinmemberVishwaKL9-Dec-12 20:19 
GeneralRe: Select All Months and related data PinmemberVishwaKL9-Dec-12 19:37 
GeneralRe: Select All Months and related data PinmemberDeepak Kr110-Dec-12 20:27 
GeneralRe: Select All Months and related data PinmemberVishwaKL10-Dec-12 20:31 
GeneralRe: Select All Months and related data PinmemberDeepak Kr110-Dec-12 22:02 
GeneralRe: Select All Months and related data PinmemberVishwaKL10-Dec-12 22:46 
GeneralRe: Select All Months and related data PinmemberDeepak Kr110-Dec-12 23:25 
QuestionSSRS 2005 Pinmemberberba6-Dec-12 7:32 
AnswerRe: SSRS 2005 PinmemberDavid Mujica6-Dec-12 8:59 
AnswerRe: SSRS 2005 Pinmemberdjj556-Dec-12 10:30 
AnswerRe: SSRS 2005 PinmemberMycroft Holmes6-Dec-12 17:57 
GeneralRe: SSRS 2005 Pinmemberberba6-Dec-12 19:06 
GeneralRe: SSRS 2005 PinmemberMycroft Holmes6-Dec-12 22:43 
QuestionSQL Group By Question [modified] Pinmemberloyal ginger6-Dec-12 6:27 
I am trying to do this in Microsoft Access. I seem to be unable to construct a 'simple' query. To illustrate, here is a sample table:
 
Field1	Field2	Amount 
A	New	10
D	Old	5
G	Old	1
H	Old	15
H	New	55
X	Old	20
Z	Old	100
Z	New	20
 
I need to group by Field1 and only return the Field2 data for the record that has the maximum number in the Amount field. I tried to use the 'First' function but Microsoft Access sort the records internally so it does not return the right value even if I pre-sort the records with a sub-query. Do you have any advice? The result should look like the table below.
 
Desired Result:
		
Field1	Field2	Max(Amount)
A	New	10
D	Old	5
G	Old	1
H	New	55
X	Old	20
Z	Old	100
I have trouble getting the value of Field2 in the record containing to the maximum value of 'Amount.'
 
Any suggestions? Thanks in advance for your time!

modified 6-Dec-12 11:51am.

AnswerRe: SQL Group By Question PinmemberBlue_Boy6-Dec-12 11:11 
GeneralRe: SQL Group By Question Pinmemberloyal ginger31-Dec-12 6:48 
QuestionIssues installing ODP.NETx64 Pinmembercpp_prgmer6-Dec-12 5:18 
AnswerRe: Issues installing ODP.NETx64 PinmemberEddy Vluggen6-Dec-12 15:37 
GeneralRe: Issues installing ODP.NETx64 PinmemberPeter_in_27806-Dec-12 16:12 
GeneralRe: Issues installing ODP.NETx64 PinmemberMycroft Holmes6-Dec-12 17:52 
AnswerRe: Issues installing ODP.NETx64 PinmemberMycroft Holmes6-Dec-12 17:53 
QuestionSQL Query - append results PinmemberAndreFratelli5-Dec-12 7:43 
AnswerRe: SQL Query - append results PinmemberChris Meech5-Dec-12 7:55 
GeneralRe: SQL Query - append results PinmemberAndreFratelli5-Dec-12 8:08 
QuestionSQL 2008 Data Base Table Design suggestion PinmemberVishwaKL5-Dec-12 0:36 
AnswerRe: SQL 2008 Data Base Table Design suggestion PinmemberSimon_Whale5-Dec-12 0:43 
GeneralRe: SQL 2008 Data Base Table Design suggestion PinmemberVishwaKL5-Dec-12 0:47 
GeneralRe: SQL 2008 Data Base Table Design suggestion PinmemberSimon_Whale5-Dec-12 0:51 
AnswerRe: SQL 2008 Data Base Table Design suggestion PinmemberPIEBALDconsult5-Dec-12 4:56 
Question[HELP] how to using array in my case? (Query & PHP) [modified] Pinmemberjimmy.suharry4-Dec-12 21:14 
AnswerRe: [HELP] how to using array in my case? (Query & PHP) PinmemberMycroft Holmes4-Dec-12 21:38 
GeneralRe: [HELP] how to using array in my case? (Query & PHP) Pinmemberjimmy.suharry4-Dec-12 21:56 
QuestionSQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 4:09 
AnswerRe: SQL query Date Sort Problem Pinmemberihoecken3-Dec-12 5:42 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:46 
AnswerRe: SQL query Date Sort Problem PinmemberEddy Vluggen3-Dec-12 6:20 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:48 
GeneralRe: SQL query Date Sort Problem PinmemberEddy Vluggen4-Dec-12 0:00 
AnswerRe: SQL query Date Sort Problem Pinmemberdjj553-Dec-12 6:46 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 20:12 
AnswerRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 9:50 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 14:12 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 14:18 
GeneralRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 17:18 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 18:29 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:57 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 19:52 
AnswerRe: SQL query Date Sort Problem PinmemberMycroft Holmes3-Dec-12 17:24 
GeneralRe: SQL query Date Sort Problem PinmemberPIEBALDconsult3-Dec-12 18:28 
GeneralRe: SQL query Date Sort Problem PinmemberAnirbanM 23-Dec-12 20:07 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150327.1 | Last Updated 27 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid