Member Avatar for ak47carbon

i have 'topic' and 'comment' fields in table of database ,when some one give comment on topic no 1 ,it save in dabase with topic number and comment,
i want show topic number with higest comment.
tell me sql query to show result

Edited by pritaeas because: Moved to mysql
  • 2 Contributors
  • 3 Replies
  • 85 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas 
SELECT count(*) AS count, topic 
FROM comments 
GROUP BY topic
ORDER BY count DESC LIMIT 1
Member Avatar for ak47carbon

nt show topic number with higest comment.
tell me sql query to show result

tell me same query if my table name is 'orange'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.