How to take value of sql table in c#

Hello @Wedi if you want to take minimum  value with respect to Each class name then you can use this query

select name_OF_Class,min(Penalty_Cost) as Cost from Table_Name  group by name_OF_Class

if you want to take minimum value from whole column then this command can be use

select min(name_OF_Class) as name_OF_Class  from Table_Name

Hi


Check this links..http://www.tutorialspoint.com/sql/sql-useful-functions.htm

  Example in c#..http://www.c-sharpcorner.com/UploadFile/rohatash/countall-vs-countdistinct-in-sql-server-2012/