SELECT POPULAR POST

by

Try :

select * from (select post_id,count(*) count_post from views group by post_id order by 2 desc) where rownum <=5;

More Related Contents:

  1. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  2. How to do the Recursive SELECT query in MySQL?
  3. MySQL foreign key constraints, cascade delete
  4. MySQL case sensitive query [duplicate]
  5. SQL Performance UNION vs OR
  6. Simulating MySQL’s ORDER BY FIELD() in Postgresql
  7. What does mysql error 1025 (HY000): Error on rename of ‘./foo’ (errorno: 150) mean?
  8. Using SQL to determine word count stats of a text field
  9. Equivalent of varchar(max) in MySQL?
  10. How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?
  11. MySQL MONTHNAME() from numbers
  12. MySQL Order before Group by
  13. How to transpose mysql table rows into columns
  14. MySQL incorrect key file for tmp table when making multiple joins
  15. “193: %1 is not a valid Win32 application” bug with a new Rails Application
  16. Does the order of conditions in a WHERE clause affect MySQL performance?
  17. Difference between these two joining table approaches?
  18. Get total number of rows when using LIMIT? [duplicate]
  19. MySQL query, MAX() + GROUP BY
  20. Convert JSON array in MySQL to rows
  21. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  22. MySQL export into outfile : CSV escaping chars
  23. Simple Random Samples from a MySQL Sql database
  24. MySQL Select minimum/maximum among two (or more) given values
  25. MySQL: Many tables or many databases?
  26. Select only last value using group by at mysql
  27. Query to count the number of tables I have in MySQL
  28. How to kill MySQL connections
  29. `MODIFY COLUMN` vs `CHANGE COLUMN`
  30. How to solve MySQL max_user_connections error

Leave a Comment