SQL PHP HTML ASP JavaScript articles and free scripts to download

SQL MIN Command

Minimum value in a numeric field can be collected by applying  MIN sql command. We will try MIN sql command and how to use it in our tables. But the best way to use MIN command is to apply it in a numeric field. Here is our table with all the records. 

id name class mark
1 John Deo Four 75
2 Max Ruin Three 85
3 Arnold Three 55
4 Krish Star Four 60
5 John Mike Four 60
6 Alex John Four 55
 
You can check SQL MAX command to get maximum or highest value of a range of records.

We will apply the MIN command here like this to the field  mark

SELECT MIN( mark ) FROM `student`

MIN(mark)
55
The command will locate the minimum  value of the mark field and return. We can define some header  like this also.

SELECT MIN(mark) as min_mark FROM `student`

min_mark
55

Minimum mark in each class

Now let us find out what is the minimum mark ( or lowest ) in each class. Here we can use the Group By command to find out the minimum mark obtained by each class
Related Tutorial
MySQL Max
MySQL Avg
MySQL Sum

SELECT class, min( mark ) as min_mark FROM `student` GROUP BY class

class min_mark
Four 55
Three 55

Here  minimum mark of each class is displayed. Since we have two class in our table so the sql command has returned two class with lowest mark in each of them. We have to use Group By clause if we ask for the query to return any other field name other than the min. Otherwise system will generate error.

Google+

hmds04-08-2011
This is great, but how would you go about getting the id of the student with the lowest mark in each class in this case.

So, to return
id class min_mark
3 Four 55
6 Three 55
Avinash Kumar21-05-2012
select name,price from table where price=(select min(price) from table);
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List
Email:  
For Email Newsletters you can trust

HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer