DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
mysql select last row for each group
SELECT
*
FROM
CUSTOMERS
WHERE
id
IN
(
SELECT
MAX
(
id
)
FROM
CUSTOMERS
GROUP
BY
PERSON_NAME
)
;
Source by thispointer.com #
PREVIOUS
NEXT
Tagged:
#mysql
#select
#row
#group
ADD COMMENT
Topic
COMMENT
Name
1+5 =
Submit