What is the query to get the number of “names” from a table that is occuring more than 10 times.
June 12th, 2008 | by Shubhabrata |SELECT name FROM table_name WHERE COUNT(name) > 10
-
Meta
Categories
Tag Cloud
Apache class class autoloading eregi_replace ereg_replace Exceptions https Implicit Inner Join join Load balancing MySQL object oop Perl PHP php.ini PHP 5 Session SOAP Implementation sqlite ssl xml
Recent Comments
- Santhosh fernando:The above queries will not giv
- Santhosh:The above queries will not giv
- Sumesh:http://www.phpnew.co.cc/
- brijmohan:Good interview question with a
- brijmohan:Good one question with answer
- Sumesh:Explain more about explicit &a
- Sumesh:Correct Query is : “SELECT
- parthiban:Hi "SELECT name FROM table_
- Ajay:Nice information and easy to r
- Pooran Jaiswal:This function is identical to
Recent Post
- Install Apache, MySQL, PHP and Perl in one shot using xampp.
- What is the difference between inner join and outer join?
- What is the query to get the number of “names” from a table that is occuring more than 10 times.
- Describe the lifecycle of object creation.
- How do you maintain session in a load balancing system?
- Which will be faster out of queries with explicit INNER JOIN and implicit one?
- What is the difference between ereg_replace and eregi_replace?
- Why PHP 5 Rocks
- Importance of Class autoloading
- How to differentiate isset and empty
5 Responses to “What is the query to get the number of “names” from a table that is occuring more than 10 times.”
By parthiban on Sep 17, 2008 | Reply
Hi
“SELECT name FROM table_name WHERE COUNT(name) > 10″ this query is not working bz the group functions are used only having clause not for where clause
so the correct query is
“SELECT name FROM table_name having COUNT(name) > 10″
By Sumesh on Sep 30, 2008 | Reply
Correct Query is :
“SELECT name FROM table_name having COUNT(name) > 10″
By Sumesh on Oct 14, 2008 | Reply
http://www.phpnew.co.cc/
By Santhosh on Oct 18, 2008 | Reply
The above queries will not give the required output so try the below query
select name from postfuel group by cabname having count(cabname) > 10;
By Santhosh fernando on Oct 18, 2008 | Reply
The above queries will not give the required output so try the below query
select name from postfuel group by cabname having count(cabname) > 10;