Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1904

Add support for SQL Count function

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Won't Do
    • Icon: Blocker Blocker
    • Future Releases
    • 3.1.3.Final
    • Query

      Support for the SQL COUNT() function would be very useful. Something along the lines of the functionality described at http://www.w3schools.com/sql/sql_func_count.asp would work well.

      SQL COUNT(column_name) Syntax

The COUNT(column_name) function returns the number of values (NULL
values will not be counted) of the specified column:
    SELECT COUNT(column_name) FROM table_name

SQL COUNT(*) Syntax

The COUNT(*) function returns the number of records in a table:
    SELECT COUNT(*) FROM table_name

SQL COUNT(DISTINCT column_name) Syntax

The COUNT(DISTINCT column_name) function returns the number of 
distinct values of the specified column:
    SELECT COUNT(DISTINCT column_name) FROM table_name

      The workaround for this is for the application to fetch all the values of one column and count the number of records itself. Not a great option when there are a large number of rows.

              Unassigned Unassigned
              bwallis42_jira Brian Wallis (Inactive)
              Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: