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 2005 Forums
 High Availability (2005)
 First() in sql

Author  Topic 

meenaprasanna
Starting Member

1 Post

Posted - 2009-07-07 : 02:53:45
is possible to use first() in sql 2000

meena

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-07 : 04:07:52
Hi meena...

i don't think so its in SQL SERVER 2000
For what purpose u want ............
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-07-07 : 05:14:24
quote:
Originally posted by meenaprasanna

is possible to use first() in sql 2000

meena


There is no such function in SQL Server. Depends on what you want you need to use min() function

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2009-07-09 : 14:54:54
Or maybe you want a SELECT TOP 1...

--------------------------------------------
Brand yourself at EmeraldCityDomains.com
Go to Top of Page
   

- Advertisement -