Originally posted by Jan Cumps: This is the logic you can follow: select the rows where you want to create the count for, use the group by clause to combine identical values use count(*) to count the number of combine records
[ August 27, 2008: Message edited by: Jan Cumps ]
How could i get the count coloumn in JSP... may i use like this.. rs.getString("count");??? Is this rite?
[ August 28, 2008: Message edited by: Rajkumar balakrishnan ]