Repeate Same String Multiple Time.

FUNCTION:  REPLICATE

SELECT REPLICATE ('ABC', 3)

OUTPUT (Print Same string 3 times)

ABCABCABC

Get Max Number or Date From List

How to find the Max From (5,8,124,498)

--Get Max Number from the list
SELECT
  (SELECT Max(v) FROM (VALUES (5), (6), (7)) AS value(v)) as [MaxValue]

  --Get Max Date from the list
SELECT  getdate(),
  (SELECT Max(v) FROM (VALUES (getdate()), (getdate()+1), (getdate()+2)) AS value(v)) as [MaxDate]

  --Syntex
SELECT
COL1,
(SELECT Max(v) FROM (VALUES (5), (6), (7)) AS value(v)) as [MaxValue],
COL2
FROM
  TABLE1