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

Add support for SQL Count function

    XMLWordPrintable

    Details

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  bwallis42 Brian Wallis
                • Votes:
                  6 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: