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

Video Demo: How to use Where Clause in Kusto Query

1 comment:

  1. I know an organization who have private investigators for hire who can help you get into your spouse’s phones,emails remotely from your phone they can also help you with your
    * credit score
    * clearing of criminal record
    *increasing of school grades etc
    You can confirm for yourself from their email or website so you can also give your testimony
    Whatsapp No: +14106350697