Web Development

Ask something
Question Locked

vb and sql

0 helpful
3 replies

by stogarepih

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i am querying for the maximum occurance of a disease and also want to know which hospital had that recording but i get all the minimum recordings where there is a minimumu temperature.i am not getting the value for 'name'
my code is like this:

sql1= "select name, min(cancer) as minimum from Hospital where disease='cold' group by name

3 replies

by john.a.wills

Why do you have a minimum in your attempt to elaborate the SQL?

by stogarepih

the minimum will be the label for the value found as min in nthe query. could that be the source of my problem

This discussion is closed to new replies.