Kumaran1987

 SELECT --43659, 43662   SalesOrderId,   SalesOrderNumber,   SubTotal,   OrderDate,   (     SELECT SUM(OrderQty)     FROM Sales.SalesOrderDetail     WHERE SalesOrderID not in (43659, 43661, 43662, 43668)   ) AS TotalSales FROM   Sales.SalesOrderHeader WHERE   SalesOrderID not in (43659, 43661, 43662, 43668); The above query explained in this below video,

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 ...

Hi all,   Welcome to 100 days of SQL script code   In this blog post, will start with AdventureWorks sample database in Microsoft SQL server   Install MS SQL server and SSMS latest version  Download bak file from https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms Follow the restore steps in the same above link after restoring below adventure work database below  Run the below query in SQL server -- showing list of tables select * from INFORMATION_SCHEMA.TABLES   output  customer and product table select query -- customer and product table  select * from SalesLT.Customer select * from SalesLT.Product Outputs are

3AaaS Common functionalities Simple Functionalities are 1. Adding or Saving 2. Removing or Deleting  3. Updating  4. Viewing individual and group of datas  5. Sort Functionalities 6. Searching Functionalities  Intermediate Functionalities are 1. Mapping 2. Merging 3. Advanced searching  Complex Functionalities are,  1. Tree structure view of all simple and Intermediate Functionalities. 2. Graph structure view of all simple and Intermediate Functionalities. Previous linkedin posts and snapshots

GEO - Geostationary/ Geosynchronous  orbit - Satellites round trip 1 time per day !! MEO - Mid Earth Orbit - Satellites round trip 2 time per day !! LEO - Low Earth Orbit - Satellites round trip 18 times per day !!  Morr information will soon updated year like distance measurements!! 

 

Unmet dependencies usually cause that installed  software already holding a lock inside cache folder. Hence to come over  this kind of issues, the following commands will help while uninstalling packages or installing packages. Step 1. Remove the lock sudo rm /var/cache/apt/archives/lock Step 2. Update apt-get sudo apt-get update Step 3. Now Install the software    sudo apt-get install [package or software] Remove/Uninstall software sudo apt-get remove [package or software]