Displaying specific data from the database

[smitanaik]

This are my database columns
1)Ipaddress(address of client machine) 2)data received (content downloaded from server)3)url(sites accesssed by the users)






I want to display Ipaddresses based on highest data received.that is first i will have to sum the data recceived by particular ip address and then display the ip address that has received highest data.

 
select ip_address,sum(data_received) from log group by ip_address,data_received ORDER BY data_received desc ;
 
 

when i try this the output I get is wrong not all the data is in descending order.

[mafaisal]

Hello

Try This

Select ip_address,Data_rec From (select ip_address,sum(data_received)  as Data_rec from log group by ip_address,data_received) as Dt Order By Data_rec  Desc
 
 

In here i think in group by option data_received is not needed
Try with that & without that to got ur output

Faisal

This are my database columns
1)Ipaddress(address of client machine) 2)data received (content downloaded from server)3)url(sites accesssed by the users)






I want to display Ipaddresses based on highest data received.that is first i will have to sum the data recceived by particular ip address and then display the ip address that has received highest data.


select ip_address,sum(data_received) from log group by ip_address,data_received ORDER BY data_received desc ;

when i try this the output I get is wrong not all the data is in descending order.

[amitpatel66]

A small change to your query :

 
select ip_address,sum(data_received) sum_data from log group by ip_address ORDER BY sum_data desc ;
 
 

The above query should give you correct results.