Count the data

[haot2307]

I have a table called program within it are several fields including:

id_program
id_student

how I want to get id_student based on highest id_program volumes of data

let say row in table:-

row 1 : id_program : 1, id_student :001,
row 2 : id_program : 2, id_student :001,
row 3 : id_program : 3, id_student :002,
row 4 : id_program : 4, id_student :001,
row 5 : id_program : 5, id_student :003.


query that i need is it will result like this :-
highest program : 001
Number program : 3

[Rabbit]

I have no idea how you went from your sample data to your results.

[haot2307]

I want to get the most id_student create programs

[Rabbit]

Yes, you've already said that, I don't know what you mean by it.

[roshan ban]

You can simply Use
Select Id_student as highest_program , Count(Id_studen t) as Number_program From Your table name

[deric]

This question belongs to SQL. Anyway, use GROUP BY and COUNT together

SELECT COUNT(id_program) AS prog, id_program, id_student FROM YourTable GROUP BY id_student