SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Wizard dethfire's Avatar
    Join Date
    Aug 2000
    Posts
    2,477
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool SQL functions

    Where can I find a site that explains all the SQL functions. I already know all the basic Selects, Joins... I'm looking for real useful stuff. For instance addition, concatonation, tops, sums...
    Free Science Homework Help
    http://www.physicsforums.com

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    SQL doesn't have functions. Each Database system implements their own functions for use within queries.
    Wayne Luke
    ------------


  3. #3
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think the basic math functions are standard SQL, e.g.
    +, -, *, /

    SUM, COUNT, MAX, MIN, AVG

    Google is your friend, this is what I found immediately on searching for 'SQL Functions'
    http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html


Bookmarks

Posting Permissions

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