SQLScientist.com
Pages
(Move to ...)
Home
About Me
Contact Us
Portfolio
SQL Server Interview Questions
▼
Friday, May 31, 2024
SQL Server Scenario Based Interview Question - 3
›
There is a database which contains below tables. Product Customer 1. Write a query which shows the count for each Products. Select P.Name...
Thursday, July 23, 2015
Write recursive t-sql code to find NTILE / DECILE / Quintile based on Salary descending for employee in the Department.
›
Write a query which will give below output. There’s a table with below data Query: Declare @v_Employee as table (...
Wednesday, July 22, 2015
Write recursive t-sql code to fill missing Salary for employee using Average for the Department.
›
There’s a table with below data Write a query which will give below output. Query: Declare @v...
Friday, March 13, 2015
Write recursive t-sql code to generate reverse of given string
›
Create Function [dbo].[fn_Reverse](@v_Input nvarchar(max)) Returns nvarchar(max) as Begin If (len(@v_Input) <> 1) Begin ret...
Write recursive t-sql code to get Factorial of integer number
›
Create Function dbo . fn_Factorial ( @v_Number bigint ) Returns bigint as Begin If ( @v_Number != 1 ) go Select dbo . fn_F...
›
Home
View web version
