15.SQL Server - STRING_AGG | CAST | CONVERT and Numeric Data Types
SQL Server Numeric Data Types and STRING_AGG
------------------------------------------------------------------------------
-- STRING_AGG is an aggregate function that concatenates rows of strings into a single string,
--separated by a specified separator. It does not add the separator at the end of the result string.
syntax: STRING_AGG (inputstring,seperator)
select * from [HumanResources].[Employee] order by JobTitle
--
SELECT JobTitle,STRING_AGG(LOGINid,',') AS LoginID
FROM
[HumanResources].[Employee]
GROUP BY JobTitle
SELECT JobTitle,STRING_AGG(LOGINid,',')
WITHIN GROUP (ORDER BY LOGINid)
AS LoginID
FROM
[HumanResources].[Employee]
GROUP BY JobTitle
-- REPLICATE IT IS JUST REPEAT THE STRING
-- SYNTAX: REPLICATE (ISTRING,NO.OF.TIMES);
SELECT REPLICATE('NAG',3)
SELECT REPLICATE('N',4)
----------------------------------------------------------------------------
NUMRIC FUNCTIONS
------------------------------------------------------------------------------
SQRT,POWER,ROUND,CEILING,LOG,SQUARE,FLOOR
-- SQRT
SELECT SQRT(36);
SELECT SQRT(25);
SELECT SQRT(5);
-- POWER
-- POWER(P,S)
SELECT POWER(2,3);
SELECT POWER(5,3);
-- ROUND
SELECT ROUND(22.3466,2);
SELECT ROUND(22.3466,3);
SELECT ROUND(22.35,2);
-- CEILING RETURNS THE NEAREST HIGHEST VALUE FOR THE GIVEN NUMBER
SELECT CEILING(41.78)
SELECT CEILING(41.45)
-- FLOOR RETURNS THE NEAREST LOWER VALUE FOR THE GIVEN NUMBER
SELECT FLOOR(23.678);
SELECT FLOOR(-23.678);
-- LOG
SELECT LOG(10);
SELECT Log10(2)
-- [Rand()] Random function is nothing but produce any value between 0 and 1
select rand(24)
select rand(23
--Sign()
SELECT SIGN(-23.678)
SELECT SIGN(23.678)
--Abs() IGNORE THE SIGNS
SELECT ABS(-23.678);
SELECT ABS(-23.678);
-------------------------------------------------------------------------------
-- SYSTEM FUNCTIONS, USED TO CONVERT, HANDLING NULLS.
--CAST
--CONVERT
--ISNULL
--ISDATE
--ISNUMERIC
--TRY_CAST
--TRY_CONVERT
#dbms #rdbms #sqlserver #ssms #database #sqlservermanagementstudio #analytics #DATA
Auf dieser Seite können Sie das Online-Video 15.SQL Server - STRING_AGG | CAST | CONVERT and Numeric Data Types mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Tech2BI 20 März 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 26 Mal angesehen und es wurde von 1 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
