Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

What is the use of GROUP by statement in MySQL?

The GROUP by statement is used with the aggregate functions to group the result by one or more columns. GROUP by Syntax SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP by column_...

How to get count of duplicate values from table in mysql?

Sometimes we need to check how many duplicate values a column has in MySQL table. We can do this by using "group by" and "having". Example: Suppose you have a table "user" with "fist_name" column from which you want to find all the records w...

MYSQL, PHP :- Query Concatenating Fields To Make Date And Running Between Query On It

Recently, I faced a problem when the date was saved in different fields month, year and date. I need to club all these fields together and run a between query on it. Another issue which was there was that Date has '0' contacted if the value ...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: