using sql count in a case statement

SELECT 
    COUNT(CASE WHEN rsp_ind = 0 then 1 ELSE NULL END) as "New",
    COUNT(CASE WHEN rsp_ind = 1 then 1 ELSE NULL END) as "Accepted"
from tb_a

You can see the output for this request HERE

Related Posts:

  1. What is the difference between UNION and UNION ALL?
  2. Selecting COUNT(*) with DISTINCT
  3. ORA-00904: invalid identifier
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. The wait operation timed out. ASP
  6. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  7. SQL SELECT WHERE field contains words
  8. Using group by on multiple columns
  9. Efficiently convert rows to columns in sql server
  10. Nested select statement in SQL Server
  11. What’s the difference between VARCHAR and CHAR?
  12. How to split the name string in mysql?
  13. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  14. Sql Server equivalent of a COUNTIF aggregate function
  15. Column name or number of supplied values does not match table definition
  16. Inserting data into a temporary table
  17. How to Select Top 100 rows in Oracle?
  18. Simple PHP Pagination script
  19. CREATE VIEW must be the only statement in the batch
  20. SQL Server FOR EACH Loop
  21. ORA-12560: TNS:protocol adaptor error
  22. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  23. SQL – HAVING vs. WHERE
  24. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  25. Oracle Apex column link from LOV values
  26. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  27. When to use “ON UPDATE CASCADE”
  28. MySQL combine two columns into one column
  29. How to SUM two fields within an SQL query
  30. DateTime2 vs DateTime in SQL Server
  31. Difference between numeric, float and decimal in SQL Server
  32. SQL Server: Invalid Column Name
  33. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  34. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  35. How do I query for all dates greater than a certain date in SQL Server?
  36. String or binary data would be truncated. The statement has been terminated
  37. Error converting data type varchar to float
  38. How to concatenate text from multiple rows into a single text string in SQL Server
  39. Count(*) vs Count(1) – SQL Server
  40. Remove duplicate rows in MySQL
  41. Cast from VARCHAR to INT – MySQL
  42. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  43. postgresql: error duplicate key value violates unique constraint
  44. Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
  45. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  46. “You tried to execute a query that does not include the specified aggregate function”
  47. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  48. Insert into a MySQL table or update if exists
  49. How to round down to nearest integer in MySQL?
  50. Convert timestamp to date in Oracle SQL
  51. How do I reset a sequence in Oracle?
  52. MySQL error: key specification without a key length
  53. SQL: Two select statements in one query
  54. Update statement with inner join on Oracle
  55. Check if MySQL table exists without using “select from” syntax?
  56. mysql update column with value from another table
  57. Can I use multiple “with”?
  58. SQL Server dynamic PIVOT query?
  59. Incorrect syntax near ”
  60. How to copy a row and insert in same table with a autoincrement field in MySQL?
  61. I want to use CASE statement to update some records in sql server 2005
  62. What does Include() do in LINQ?
  63. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  64. Get everything after and before certain character in SQL Server
  65. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  66. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  67. ROW_NUMBER() in MySQ
  68. LEFT function in Oracle
  69. Foreign key references invalid table
  70. What are database constraints?
  71. Postgresql column reference “id” is ambiguous
  72. How do I view the Explain Plan in Oracle Sql developer?
  73. ORA-01779: cannot modify a column which maps to a non key-preserved table
  74. SUM OVER PARTITION BY
  75. SQLite string contains other string query
  76. Varchar invalid for Sum operator
  77. SQL: How to properly check if a record exists
  78. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  79. Sorting search results by taxonomy terms
  80. SQL select of users by metadata
  81. WordPress SQL LIKE request doesn’t work for fields with special symbols
  82. posts_where Fails with More than One Custom Field in Query
  83. WordPress database error: You have an error in your SQL syntax
  84. Restose content from revisions – sql query
  85. Better way to migrate to server?
  86. Inner Join user tables to select users with roles
  87. $wpdb->prepare with LIKE returning blank array instead of rows
  88. Why line returns are not reapply after doing esc_sql?
  89. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  90. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  91. Help me SELECT thumbnail from SQL and use
  92. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  93. Search results sort order failing: set by date only
  94. Creating a “forum” – showing last post or last commented post
  95. Replace Unwanted Space in Post Content URL
  96. SQL to transform all email addresses in my DB in lowercase [closed]
  97. How to write inner join using posts_clauses?
  98. How to get the sum of each post with the same date
  99. How to dump a Microsoft SQL Server database to a SQL script?
  100. Deleting the MySQL database

Leave a Comment