Deshaw Inc Interview Question
SDETsCountry: India
Interview Type: In-Person
create table #TempTab (Name varchar(100), MName varchar(100), LName varchar(100))
insert into #TempTab VALUES('John', 'A', 'Tree')
insert into #TempTab VALUES('John', 'B', 'Apple')
insert into #TempTab VALUES('Linda', 'C', 'Orange')
insert into #TempTab VALUES('Mark', 'D', 'Honda')
insert into #TempTab VALUES('Rob', 'E', 'Boeing')
select MAX(LEN(CONCAT(Name, MName, LName))) FROM #TempTab
create table name
([1stName] nvarchar(20),
[2ndName] nvarchar(20),
[MiddleName] nvarchar(20))
insert into name values ('John','A','Tree')
insert into name values ('Linda','B','Apple')
insert into name values ('Bob','c','Boeing')
insert into name values ('Mark','c','dee')
select * into #a
From (select *,Row_number() over (order by [1stName],[2ndName],[MiddleName]) as RowNo From name) as t
unpivot (name_value for name in ([1stName],[2ndName],[MiddleName]) ) a
select #a.name,#a.name_value from #a,(select Rowno,max(len(name_value)) as name_len from #a group by Rowno) as b
where #a.RowNo=b.RowNo and len(#a.name_value)=b.name_len
- shivam February 23, 2015