how to retrieve the most entered value from database mssql using vb.net ?
Posted
by
D Infosystems
on Stack Overflow
See other posts from Stack Overflow
or by D Infosystems
Published on 2011-01-10T12:49:15Z
Indexed on
2011/01/10
15:53 UTC
Read the original article
Hit count: 155
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..
© Stack Overflow or respective owner
