This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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 ]