Posts

Showing posts from November 3, 2021

Quantum Internet Benefits

Image
  The quantum internet is a network of quantum computers that are connected together using quantum communication. It has the potential to revolutionize many industries, including: Secure communications: The quantum internet would be inherently secure, as it would be impossible to eavesdrop on quantum communications without being detected. This could be used for applications such as secure financial transactions, government communications, and military applications. Quantum computing: The quantum internet would allow quantum computers to be connected together, which would allow them to solve problems that are currently impossible for classical computers. This could be used for applications such as drug discovery, financial modeling, artificial intelligence, and materials science. Quantum sensors: The quantum internet could be used to connect quantum sensors together, which would allow them to create a global network of sensors that could be used to monitor the environment, detect earthq

SQL Where Queries : Day 2 #100Days of SQL

Image
Today, I am going to share about Where clause usages in SQL Query using Microsoft SQL server and AdventureWorks Database. We Will gonna use "Production.Product" Table in this examples, In this blogpost will see about where clause with other operators such as and, or, like, not null, null  Initially we will explore about Simple SQL where clause queries here, Later I will update more complex SQL where clause queries in future days. At First we will see the normal Query with resultsets select * from Production.Product  -- returned 504 rows of data In this below Query we will see about Safety Stock level value below 1000 -- where query for SafetyStock level below 1000 select Production.Product.ProductID,         Production.Product.Name,    Production.Product.SafetyStockLevel from   Production.Product where  Production.Product.SafetyStockLevel < 1000    In this below query will explore safety stock level values are above 600\ -- where query for SafetyStock level above 600 s