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
Nesta página do site você pode assistir ao vídeo on-line 15.SQL Server - STRING_AGG | CAST | CONVERT and Numeric Data Types duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Tech2BI 20 Março 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 26 vezes e gostou 1 espectadores. Boa visualização!
