SQL query to select distinct row with minimum value

by

Use:

SELECT tbl.*
FROM TableName tbl
  INNER JOIN
  (
    SELECT Id, MIN(Point) MinPoint
    FROM TableName
    GROUP BY Id
  ) tbl1
  ON tbl1.id = tbl.id
WHERE tbl1.MinPoint = tbl.Point

More Related Contents:

  1. SQL Data models
  2. Get top results for each group (in Oracle)
  3. How to randomly select rows in SQL?
  4. What’s the difference between TRUNCATE and DELETE in SQL
  5. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  6. SQL best practice to deal with default sort order
  7. How can I get column names from a table in Oracle?
  8. single fixed table with multiple columns vs flexible abstract tables
  9. How can I send email from PostgreSQL trigger?
  10. How to get a list of column names on Sqlite3 database?
  11. How to design a database for User Defined Fields?
  12. How to delete Duplicates in MySQL table
  13. Composite Primary key vs additional “ID” column?
  14. mySQL Returning the top 5 of each category
  15. Logging ALL Queries on a SQL Server 2008 Express Database?
  16. Normalization in plain English
  17. Core Data Performance with Single Parent Entity
  18. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  19. Why does VARCHAR need length specification?
  20. How to Optimize Queries in a Database – The Basics
  21. SQL server select distinct rows using most recent value only
  22. How can I implement SQL INTERSECT and MINUS operations in MS Access
  23. Postgres Error: More than one row returned by a subquery used as an expression
  24. Does ‘Select’ always order by primary key?
  25. How do I create and query linked database servers in SQL Server?
  26. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  27. Should I commit or rollback a read transaction?
  28. Why are foreign keys more used in theory than in practice?
  29. What is difference between foreign key and reference key?
  30. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?

Leave a Comment