How to use Where Clause in Kusto Query | Kusto Query Language Tutorial (KQL)

Topic: How to use Where Clause in Kusto Query Language.


How to use the Where clause in Kusto Query Language | Kusto Query Language Tutorial (KQL) Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modeling, and more. The query uses schema entities that are organized in a hierarchy similar to SQL's: databases, tables, and columns. A Kusto query is a read-only request to process data and return results. The request is stated in plain text, using a data-flow model that is easy to read, author, and automate. Kusto queries are made of one or more query statements.

 How to use the Where Clause in Kusto   
   
 //How to use Where with equal   
 TotalSale  
 | where SalePersonFName =="Aamir"  
   
 //How to get data with Where Clause By ignoring Case Senstivity  
 TotalSale  
 | where SalePersonFName =~"Aamir"  
   
 // Where clause with multiple columns  
 TotalSale  
 | where ProductName =="TV" and City =="High Point"  
   
 TotalSale  
 | where ProductName =="TV" | where City =="High Point"  
   
 //Where Clause with > or < or >= or <=  
 TotalSale  
 | where id>10  
   
 TotalSale  
 | where id<10  
   
 TotalSale  
 | where id>=10  
   
 TotalSale  
 | where id<=10  
   
   
 // Where Clause with Like operator  
 TotalSale  
 | where SalePersonFName contains "aa"  
   
 //Where clause with "%abc"  
 TotalSale  
 | where SalePersonFName startswith "Ch"  
   
 // Where clause where "abc%"  
 TotalSale  
 | where SalePersonFName endswith "ty"  
   
 //using Regex , should start with LA and ends with anything  
 TotalSale  
 | where ProductName matches regex "^La.*"  

Video Demo: How to use Where Clause in Kusto Query

1 comment:

  1. SYNACK TECH IS FAST AND EFFECIENT
    You really need to be careful of the risk involved in the world of cryptocurrency and investments. I was naive enough to believe I could make huge returns from my cryptocurrency investments without doing proper research about it. I lost $543,000 worth of USDT and BTC in a failed cryptocurrency investment scheme. Luckily for me, I was able to reach out to a reputable cryptocurrency recovery company that goes by the name Synack Tech and was able to successfully recover all the money I had invested into the scheme. {{{s y n a c k h a c k @ t e c h | - | c e n t e r | d o t | c o m }}} I’m forever grateful to the services of Synack Tech and this message is a recommendation to everyone who intends to recover lost digital assets of any kind. Not only are they fast but also reliable and they update you on the progress accordingly.

    ReplyDelete