how to retrieve the most entered value from database mssql using vb.net ?
- by D Infosystems
if i have mssql database with record displayed below :
Id Serv-code Value
1 100 3
2 100 4
3 100 3
4 100 3
5 101 5
6 101 5
the logic i want when i search for the record using serv_code 100 then the output will be the average means 3 will be displayed in textbox because the value 3 will be entered 3 times than 4 as shown above .... and if if i search record with serv_code 100 and if the value of serv_code is equal means 3 and 4 only then the recent entered value will be displayed in textbox..