Linked Questions

Ask Question
25 questions linked to/from Max function in SQL Server that takes two values like Math.Max in .NET
Hot Newest Score Active Unanswered
7 votes
1 answer
50k views

Is it possible to return zero if a value is less than zero without using a case statement? e.g. Max(a, 0) <-- 'Max' doesn't exist. I would like my code to be as succinct as possible.
Ian Warburton's user avatar
  • 15.8k
10 votes
4 answers
17k views

Possible Duplicate: Is there a Max function in SQL Server that takes two values like Math.Max in .NET? In Excel, there's a function called "MAX" that accepts numbers and returns the largest one in ...
SqlRyan's user avatar
  • 34k
3 votes
3 answers
175 views

In SQL Server 2008, I need to query across columns in T-SQL and return the largest number I find (example below using dates, but same idea applies to numbers). "NULL" indicates a null value, not the ...
Clint Finch's user avatar
  • 101
1 vote
0 answers
254 views

I need to do an insert where one column is to be a calculated numerical value based on a value from another table, yet restricted between upper and lower bounds. Let's call these @lower_bounds and @...
n00bd00d's user avatar
  • 15
546 votes
24 answers
927k views

How do you return 1 value per row of the max of several columns: TableName [Number, Date1, Date2, Date3, Cost] I need to return something like this: [Number, Most_Recent_Date, Cost] Query?
BenB's user avatar
  • 10.7k
121 votes
21 answers
395k views

Given the following table in SQL Server 2005: ID Col1 Col2 Col3 -- ---- ---- ---- 1 3 34 76 2 32 976 24 3 7 235 3 4 245 1 792 What is ...
stucampbell's user avatar
  • 6,633
278 votes
2 answers
145k views

How do I find the maximum (or minimum) of two integers in Postgres/SQL? One of the integers is not a column value. I will give an example scenario: I would like to subtract an integer from a column (...
HRJ's user avatar
  • 17.9k
52 votes
8 answers
117k views

This should be simple and shows my SQL ignorance: SQL> select max(1,2) from dual; select max(1,2) from dual * ERROR at line 1: ORA-00909: invalid number of arguments I know max is normally ...
Peter G.'s user avatar
  • 15.2k
17 votes
4 answers
7k views

Is there something like select max(val,0) from table I'm NOT looking to find the maximum value of the entire table There has to be an easier way than this right? select case when val > 0 then ...
Colin's user avatar
  • 2,187
6 votes
6 answers
15k views

I seem to be stuck on this and can't find a solution having had a look around. I have an SQL table who's first row looks something like this: Name Val1 Val2 Val3 John 1000 2000 3000 What ...
Johnathan's user avatar
  • 919
3 votes
4 answers
9k views

I am trying to cap particular fields so that they don't exceed a particular value. For example, something like this would suffice, where I can specify that a field should not exceed 8: SELECT ( ...
joshschreuder's user avatar
  • 1,473
10 votes
4 answers
7k views

How to implement the scalar MAX in Sql server (like Math.Max). (In essense I want to implement something like Max(expression, 0), to make negative values replaced by 0.) I've seen in other threads ...
Rein's user avatar
  • 2,637
2 votes
3 answers
12k views

I've been looking for a good equivalent to the Oracle LEAST function. I'm hoping to implement a user defined function that does about 10 fairly complex calculations, and takes the minimum value from ...
Jade's user avatar
  • 1,800
3 votes
4 answers
4k views

I'm doing a small calculation in the select statement of an sql query along the lines of this: SELECT (select sum(weighting) from table1 where id = tablemain.id) * (select sum(...
user1085867's user avatar
  • 71
4 votes
0 answers
21k views

Possible Duplicate: SQL Server equivalent to Oracle LEAST? Function in SQL Server 2008 similar to GREATEST in mysql? i am trying to find a SQL Server equivalent of oracle's "GREATEST" function. ...
Madam Zu Zu's user avatar
  • 6,675

15 30 50 per page
1
2