SQL Puzzle #1 - Write the shortest code that produces results as 1 without using any numbers in the select statement.

Ans:

SELECT DIFFERENCE('Ant', 'Elephant')

SELECT DATALENGTH(' ')

SELECT LEN('x')

SELECT ISNUMERIC($)

SELECT ISNUMERIC('+')

SELECT ISNUMERIC('-')

SELECT ISNUMERIC('.')

SELECT COUNT_BIG(*)

SELECT COUNT(*)

SELECT CEILING(RAND())

SELECT ISDATE(GETDATE())

SELECT MONTH(GETDATE())/MONTH(GETDATE())

SELECT DAY(GETDATE())/DAY(GETDATE())

SELECT YEAR(GETDATE())/YEAR(GETDATE())

SELECT POWER($,$)

SELECT ISNULL(NULL,COUNT(*))

SELECT LEN(NEWID())/LEN(NEWID())

SELECT @@SPID/@@SPID

SELECT UNICODE('A')/ UNICODE('A')

SELECT ISNUMERIC(@@SPID)

SELECT COS('')

SELECT ROW_NUMBER() over (order by A )From (Select 'A' As A )A

select Count('a')

Select SCHEMA_ID()

Select COUNT(Schema_id())

Select Len(Schema_id())

Select CHARINDEX('A','A')

Select LEN(CHARINDEX('A','A'))

Select Count(CHARINDEX('A','A'))