Max function

Results 1 to 3 of 3

Thread: Max function

  1. #1
    Join Date
    Dec 1969

    Default Max function

    I know there is a max function in SQL <BR>Strsql="select max mydate from tblBlah"<BR> mydsn,strsql<BR>etc<BR>but this isn&#039t right - can anyone give me an example or tell me where I&#039m going wrong <BR>cheers<BR>;)<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Max function

    In sql server 7,<BR><BR>it goes like <BR><BR>select max(userid) from users where ....<BR><BR>der ya go

  3. #3
    Sathiya Guest

    Default RE: Max function

    Strsql="select max(mydate) from tblBlah"<BR>try this<BR><BR>I think max will work with numeric i dont know it works with Date or not if it works great.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts