Results 1 to 4 of 4

Thread: SQL count returns 'nothing" instead of 0

  1. #1
    Member
    Join Date
    Apr 2013
    Posts
    88

    SQL count returns 'nothing" instead of 0

    Should'nt a count on a table return 0 is no record is found? (as on all other databases)

    open database southwind
    select count(1) from employees where employeeid>0
    No records selected
    EXPR0001

    9

    9 records selected in 6ms
    select count(1) from employees where employeeid<0
    No records selected
    close database

    Regards

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,661
    Hi,

    Can you Submit a ticket for this, please?

    Thanks,

    Yvonne

  3. #3
    Member
    Join Date
    Apr 2013
    Posts
    88
    done
    Regards

  4. #4
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,661
    Thanks!

Tags for this Thread

Bookmarks

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
  •  
Journey into the Cloud
Join us