DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
SCRIPT & CODE EXAMPLE
CODE EXAMPLE FOR SQL
Having count greater than 1 mysql
SELECT
*
FROM
`
users
`
WHERE
AND
`
status
`
=
1
GROUP
BY
name
HAVING
COUNT
(
*
)
>
1
ORDER
BY
`
id
`
DESC
Source by stackoverflow.com #
PREVIOUS
NEXT
Tagged:
#Having
#count
#greater
#mysql
ADD COMMENT
Topic
COMMENT
Name
6+8 =
Submit