Ticker

6/recent/ticker-posts

Write the queries to demonstrate the working of Summaries operation.



<?php
$conn=mysqli_connect('localhost','root','','sum');
if(!$conn){
echo "Data base connection fail";
}
$sumation="select sum(salary) as `salary_sumation` from stud";
$min="select min(salary) as `Minmum` from stud";
$max="select max(salary) as `Maximum` from stud";
$avg="select avg(salary) as `Average` from stud";
$count="select count(salary) as `Count` from stud";
$res_sum=mysqli_query($conn,$sumation);
$data_sum=mysqli_fetch_array($res_sum);
$res_min=mysqli_query($conn,$min);
$data_min=mysqli_fetch_array($res_min);
$res_max=mysqli_query($conn,$max);
$data_max=mysqli_fetch_array($res_max);
$res_avg=mysqli_query($conn,$avg);
$data_avg=mysqli_fetch_array($res_avg);
$res_count=mysqli_query($conn,$count);
$data_count=mysqli_fetch_array($res_count);
echo "Sumation is : \n ".$data_sum['salary_sumation'];echo "<br>";
echo "\n Minmum is : \n ".$data_min['Minmum'];echo "<br>";
echo "\n Maximum is : \n ".$data_max['Maximum'];echo "<br>";
echo "\n Average is : \n".$data_avg['Average'];echo "<br>";
echo "\n Count is :\n ".$data_count['Count'];echo "<br>";
  ?>

Post a Comment

0 Comments