Posts

Showing posts from November 10, 2021

Quantum Internet Benefits

By
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
Post a Comment
Read more

SQL Join Query - Building Complex Join Query - Day 5 #100days of SQL

By
Image
 Hi , In this blog post will check the join queries SQL Join function below diagram shows difference possibilities   Below queries has been executed on the video podcast -- will see about join query from the db table schema diagram -- will check about product and transaction history table on join  query select * from Production.Product  -- 504 records select * from Production.TransactionHistory  -- 113443 records -- inner join select * from Production.Product p inner join Production.TransactionHistory t on p.ProductID = t.ProductID  -- full join or full outer join select * from Production.Product p full outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- right join or right outer join select * from Production.Product p right outer join Production.TransactionHistory t on p.ProductID = t.ProductID -- left join or left outer join select * from Production.Product p left outer join Production.TransactionHistory t on p.ProductID = t.ProductID  -- now will complex join
Post a Comment
Read more