Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 search for a built-in function

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-21 : 08:52:02
gopal writes "what is the equivalent function in sql-server for the function
least and greatest used in oracle."

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-21 : 08:59:32
There is nothing like it in SQL.

You'll have to put all your values in a table and do a max() or min() on the column.

You see Oracle, although marketed as a relational databases, doesn't like to work with sets of data. (well, not that SQL Server much better ) ...

Jay White
{0}
Go to Top of Page
   

- Advertisement -