The code is
Select top 100 s.i nt_cj * 10 as price band, count (s.i nt_cj) as passenger flow, the sum (s.s um_cj) as the amount of the from
Sydbak d, (
Select the convert (int, sum (cj))/10 as int_cj, sum (cj) as sum_cj, d#
The from sysbak, sydbak
Where s #=d# and ZCD/1000=x_/1000
And ct>='15-07-13' and ct<'15-07-14' group by d#
) s
Where d.s # #=s.d.
Group by s.i nt_cj
Having s.i nt_cj & gt;=0
The order by s.i nt_cj;
Hope this software can connect to a SQL database account and password, and you can enter your time of SQL database data, hope will have a great god help me, thank you less

CodePudding user response:

Hope this software can connect to a SQL database account and password, and you can enter your time of SQL database data, hope will have a great god help me, thank you very not
Answer: you can use a few text box to display the account and password of the current database, and then allow the user to edit can achieve you to change the function of the connection parameters, of course, to find a place to save the modified data, such as the registry or.ini file

The input query time, can use the data with search parameters window, if not clear, baidu