Kumaran1987

 Sql Query with Where clause select ProductSubcategoryID, size, StandardCost, ListPrice, class, style from  Production.Product where ProductSubcategoryID is not null and  size is not null and StandardCost <> 0.00 and  ListPrice <> 0.00 and  class is not null and  style is not null     -- Complex SQL query with where, group by, having clauses and top, rank, dense_rank, row functions select Top 20 ProductSubcategoryID,  Max(StandardCost) as MaximumStdCost,  Max(ListPrice) as MaxListPrice, Max(ListPrice) - Max(StandardCost) as MaxDifferenceStandardFin, Max(ListPrice) / Max(StandardCost) as CostPriceRatio, Rank() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as DistinctRankMaximumCostPriceRatio, Row_Number() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as RankMaximumCostPriceRatio, DENSE_RANK() over( Order by(Max(ListPrice) / Max(StandardCost)) Desc) as DistinctRankwithNextSequence from  Production.Pro...

Hi In this blog post I am sharing about to installing MySQL server in linux ubuntu 21 using shell scripting   In that shell scripting include that install package related dependencies for MySQL server that will address compatabilty with linux related packages like debians.   After that run the shell script command using exexcutable file like chmod +x filename.sh and then execute the shell script file which has the sudo commands in it.   Once completed executing the command, MySQL server will be installed in your linux ubunutu 21 OS.  Check the MySQL version using "mysql -v"   Run the SQL commands using mysql in that linux terminal I have used the below SQL commands   > Use [databasename]  > show [table_name]  > show columns from [table_name]   Watch this below video for more details

Hi all, In this video  - Setting new password for Super User , Root level privileges between Sudo -i vs Su Root options  - After that will installing the Python new package 3.10.0  

 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,