sql query construction help

[chupacabra]

hi guys.


I need to construct a query to get the following data.


select (param1, param2, param3) WHERE Param2 = (Max(param2)-1)


much simplified, of course. but how can i do this with a SQL query?

[chupacabra]

ok and just realized, not EXACTLY -1. but like -1 ± .3

[Phil Weber]

You don't mention what database you're using, but you might try this:

SELECT (param1, param2, param3) FROM TableName
WHERE param2 = (SELECT Max(param2) - 1 FROM TableName)

[chupacabra]

You don't mention what database you're using, but you might try this:

SELECT (param1, param2, param3) FROM TableName
WHERE param2 = (SELECT Max(param2) - 1 FROM TableName)

Access 03



is there a way i can do it -1 plus or minus 0.3 ?

[chupacabra]

got it. thanks Phil.


this is for my application, but maybe someone else would need something similar

SELECT DISTINCT [Table_Name].[Param1], [Table_Name].[Param2], [Table_Name].[Param3], [Table_Name].[Param4], [Table_Name].[Param5], [Table_Name].[Param6], [Table_Name].Param7, [Table_Name].Param8, [Table_Name].Param9, [Table_Name].Param10, [Table_Name].[Param11]
FROM Table_Name
WHERE	(
	((([Table_Name].[Param3])=3.3) AND (([Table_Name].[Param4])=0.2) AND (([Table_Name].[Param5])=100) AND (([Table_Name].[Param6])=4900) AND (([Table_Name].Param7)="CWRF") AND (([Table_Name].Param8)="AN1-RA1") AND (([Table_Name].Param9)="AN1-RA1") AND (([Table_Name].[Param11])=25) AND ([Table_Name].Param10 Like "*5")) AND
	([Table_Name].[Param2])>(
	SELECT (MAX([Table_Name].[Param2])-1.01) FROM [Table_Name]
	WHERE ((([Table_Name].[Param3])=3.3) AND 
	(([Table_Name].[Param4])=0.2) AND 
	(([Table_Name].[Param5])=1) AND 
	(([Table_Name].[Param6])=4) AND 
	(([Table_Name].Param7)="CW") AND 
	(([Table_Name].Param8)="this") AND 
	(([Table_Name].Param9)="this") AND 
	(([Table_Name].[Param11])=25)
	AND ([Table_Name].Param10 Like "*5")
	))
	AND 
	(([Table_Name].[Param2])<(SELECT (MAX([Table_Name].[Param2])-0.99) FROM [Table_Name]
	WHERE (
	(([Table_Name].[Param3])=3.3) AND 
	(([Table_Name].[Param4])=0.2) AND 
	(([Table_Name].[Param5])=1) AND 
	(([Table_Name].[Param6])=4) AND 
	(([Table_Name].Param7)="CW") AND 
	(([Table_Name].Param8)="this") AND 
	(([Table_Name].Param9)="this") AND 
	(([Table_Name].[Param11])=25) AND 
	([Table_Name].Param10 Like "*5")
	)	))
	);