How to output only 1 if data same [closed]

by

You can make your query like this for getting same result that you want – 

SELECT SUM(Total) as total,Name from table_name group by Name;

More Related Contents:

  1. query to find number of employees under each manager
  2. Adding an identity to an existing column
  3. String_agg for SQL Server before 2017
  4. Why would someone use WHERE 1=1 AND in a SQL clause?
  5. What is the purpose of system table master..spt_values and what are the meanings of its values?
  6. Unrecognized name: employees at [9:8]
  7. SQL ROWNUM how to return rows between a specific range
  8. Delete sql rows where IDs do not have a match from another table
  9. Why do people hate SQL cursors so much? [closed]
  10. Find closest numeric value in database
  11. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0
  12. SQL: parse the first, middle and last name from a fullname field
  13. Permanently Set Postgresql Schema Path
  14. How can you tell if a value is not numeric in Oracle?
  15. Call dynamic SQL from function
  16. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  17. Slow simple update query on PostgreSQL database with 3 million rows
  18. How do I alter the position of a column in a PostgreSQL database table?
  19. How to export image field to file?
  20. Move SQL data from one table to another
  21. How to unpivot in BigQuery?
  22. Nested select statement in SQL Server
  23. How to convert PostgreSQL 9.4’s jsonb type to float
  24. Find rows that have the same value on a column in MySQL
  25. Referencing current row in FILTER clause of window function
  26. How to Execute SQL Query without Displaying results
  27. How to insert a string which contains an “&”
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. PostgreSQL – dynamic value as table name [duplicate]
  30. Why are aggregate functions not allowed in where clause

Leave a Comment