Top 5 SQL Tricky Interview Questions | HCL SQL Interview Questions | SQL Server 2020 | Part 60

HCL SQL Questions and Answers 2020

For SQL Quiz-

Find Us On FaceBook-

[ssunitech]

Declare @i int=1
;With Cte
as
(
Select @i as id
Union All
Select id+2
From Cte where id<=99
)
Select * From Cte

---Question 2----


Declare @i int=1
Declare @j int=1

Print @i
Print @j

While @i<10
Begin
print @i
print @j
End

----Question 3----

USE SSIS_TEST

SELECT * FROM [DBO].[SOURCE]
SELECT * FROM [DBO].[TARGET]

Merge [TARGET] AS T
Using [SOURCE] As S
On T.id=S.Id
When Matched Then
Update Set T.name = S.Name;


----Question 4----


Select * From HCL


Select *, DENSE_RANK() over (order by cast(marksgain as numeric(14, 2))/Totalmarks desc) as rw
From HCL

[priyankasarkar]

Thank you so much sir! I have some doubts .. if you have 1million distinct value, for tuning purpose which index is good?? Btree or Unique?? can you please explain what is the difference between view and trigger?? If you have any extra Accenture related interview questions, kindly share with us, I know you have already uploaded few questions..

[Raj-phpy]

Thank you, as always very nice content

[g.suresh]

Sir make videos on DBCC Commands. Thank You

[omkaryadav]

I'm having interview wit hcl tomorrow...wanted to ask what they will ask in interview.. whatever we are mentioned in our resume questions based on that or outside also... I'm a fresher.

[Gatherit-Sivasankaran]

This is for fresher or experienced tell

[vanimaggo]

sir this interview was for which profile

[gulugulu]

sir if we tried for the output and we get error . then do they consider us