Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use shark". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian and go deep into it slowly to study and learn "how to use shark" together.

//query how many rows of data there are

Select count(*) from SOGOUQ1;

//Display the first 10 rows of data

select * from SOGOUQ1 limit 10;

//session query ranking

select WEBSESSION,count(WEBSESSION) as cw from sogouQ1 group by WEBSESSION order by cw desc limit 10;

//create cache table

create table sogouQ1_cached as select * from sogouq1;

//How many search results ranked first, but click order ranked second?

select count(*) from sogouQ1_cached where S_SEQ=1 and C_SEQ=2;

//How many search URLs do you click that contain baidu data?

select count(*) from sogouQ1_cached where WEBSITE like '%baidu%';

//Search results ranked 1st, but click order ranked 2nd,URL contains baidu data how many?

select count(*) from sogouQ1_cached where S_SEQ=1 and C_SEQ=2 and WEBSITE like '%baidu%';

//session query ranking

select WEBSESSION,count(WEBSESSION) as cw from sogouQ1_cached group by WEBSESSION order by cw desc limit 10;

***************************************************************

***************************************************************

***************************************************************

//switch database

use saledata;

//Total sales in all orders

//select sum(b.amount) from tblStock a,tblStockDetail b where a.ordernumber=b.ordernumber

select sum(tblStockDetail.amount) from tblStock join tblStockDetail on tblStock.ordernumber=tblStockDetail.ordernumber;

43129783

68100782

//select sum(b.amount) from tblStock a,tblStockDetail b,tbldate c where a.ordernumber=b.ordernumber and a.dateid=c.dateid;

select sum(tblStockDetail.amount) from tblStock join tblStockDetail on tblStock.ordernumber=tblStockDetail.ordernumber join tbldate on tblstock.dateid=tbldate.dateid;

43128080 shark

68099079 hive

Thank you for your reading. The above is the content of "how to use shark." After studying this article, I believe everyone has a deeper understanding of how to use shark. The specific use situation still needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.