• Home
  • SQL Server
    • Articles
    • T-SQL Puzzles
    • Output Puzzles
    • Interview Questions
    • Performance Tuning
    • SQL SERVER On Linux
    • Resources
  • SSRS
    • SSRS Articles
    • Interview Questions
  • SSAS
    • SSAS Articles
    • DAX
  • SQL Puzzles
  • Interview Questions
    • SQL Interview Questions
    • Data Interview Questions
  • Python Interview Puzzles
  • New Features(SQL SERVER)
    • SQL SERVER 2017
    • SQL SERVER 2016
    • SQL SERVER On Linux
  • Social
    • Expert Exchange
      • Top Expert in SQL
      • Yearly Award
      • Certifications
      • Achievement List
      • Top Expert of the Week
    • HackerRank (SQL)
    • StackOverflow
    • About Me
      • Contact Me
      • Blog Rules

Improving my SQL BI Skills

Improving my SQL BI Skills

Daily Archives: March 26, 2015

T-SQL Query | [ Group By on Multiple Columns Puzzle ]

26 Thursday Mar 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 8 Comments

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL pl/sql puzzles, SQL Puzzles, SQL SERVER Interview questions, SQL SERVER2005/2008, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ Group By on Multiple Columns Puzzle ]  – In this puzzle we have to count a’s for different Typ’s in columns Value1, Value2 and Value3. E.g. in sample data there are 3 a’s for Typ I and 1 a for Typ o. Please check out the sample input and expected output for details. Sample Input

ID Typ Value1 Value2 Value3
1 I a b
2 O a d f
3 I d b
4 O g l
5 I z g a
6 I z g a

Expected Output

Typ Counts
I 3
O 1

Rules/Restrictions

  • The solution should be should use “SELECT” statement or “CTE”.
  • Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script Use the below script to generate the source table and fill them up with the sample data.


--Create table
CREATE TABLE GroupbyMultipleColumns
(
ID INT
,Typ VARCHAR(1)
,Value1 VARCHAR(1)
,Value2 VARCHAR(1)
,Value3 VARCHAR(1)
)
GO

--Insert Data
INSERT INTO GroupbyMultipleColumns(ID,Typ,Value1,Value2,Value3)
VALUES
(1,'I','a','b',''),
(2,'O','a','d','f'),
(3,'I','d','b',''),
(4,'O','g','l',''),
(5,'I','z','g','a'),
(6,'I','z','g','a')

--Verify Data
SELECT ID,Typ,Value1,Value2,Value3 FROM GroupbyMultipleColumns

Update May 14 | Solutions



--


---------------------------------------
--Sol 1
---------------------------------------

SELECT 
       Typ
       ,SUM(CASE Value1 WHEN 'a' THEN 1 ELSE 0 END) 
       +SUM(CASE Value2 WHEN 'a' THEN 1 ELSE 0 END)
       +SUM(CASE Value3 WHEN 'a' THEN 1 ELSE 0 END)
       Counts 
FROM GroupbyMultipleColumns
GROUP BY Typ


--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

http://MSBISkills.com

T-SQL Query | [ The Football Puzzle ]

26 Thursday Mar 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 3 Comments

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL pl/sql puzzles, SQL Puzzles, SQL SERVER Interview questions, SQL SERVER2005/2008, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ The Football Puzzle ]  – In this puzzle we have to find 100th Champion which has most number of championships overall. Please check out the sample input and expected output for details.

Sample Input

club_id club_name championship_year year_100th_champion
1 FENERBAHCE 2007 1
2 GALATASARAY 2006 0
3 BESIKTAS 2003 1
1 FENERBAHCE 2005 0
1 FENERBAHCE 2004 0
2 GALATASARAY 2002 0
2 GALATASARAY 2000 0
2 GALATASARAY 1999 0
2 GALATASARAY 1998 0
2 GALATASARAY 1997 0
1 FENERBAHCE 1996 0
1 FENERBAHCE 2001 0
1 FENERBAHCE 1989 0
1 FENERBAHCE 1985 0

Expected Output

club_name
FENERBAHCE

Rules/Restrictions

  • The solution should be should use “SELECT” statement or “CTE”.
  • Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script

Use the below script to generate the source table and fill them up with the sample data.


--Create table

Create table tr_football_league
(
club_id INT,
club_name Varchar(32),
championship_year INT,
year_100th_champion INT
)

--Insert Data
insert into tr_football_league values (1, 'FENERBAHCE', 2007, 1) ;
insert into tr_football_league values (2, 'GALATASARAY', 2006, 0) ;
insert into tr_football_league values (3, 'BESIKTAS', 2003, 1) ;
insert into tr_football_league values (1, 'FENERBAHCE', 2005, 0) ;
insert into tr_football_league values (1, 'FENERBAHCE', 2004, 0) ;
insert into tr_football_league values (2, 'GALATASARAY', 2002, 0) ;
insert into tr_football_league values (2, 'GALATASARAY', 2000, 0) ;
insert into tr_football_league values (2, 'GALATASARAY', 1999, 0) ;
insert into tr_football_league values (2, 'GALATASARAY', 1998, 0) ;
insert into tr_football_league values (2, 'GALATASARAY', 1997, 0) ;
insert into tr_football_league values (1, 'FENERBAHCE', 1996, 0);
insert into tr_football_league values (1, 'FENERBAHCE', 2001, 0) ;
insert into tr_football_league values (1, 'FENERBAHCE', 1989, 0) ;
insert into tr_football_league values (1, 'FENERBAHCE', 1985, 0) ;

--Verify Data
SELECT club_id, club_name , championship_year , year_100th_champion FROM tr_football_league

Update May 14 | Solutions



--


---------------------------------------
--Sol 1
---------------------------------------

;WITH CTE AS
(
	SELECT club_name,
	year_100th_champion,
	COUNT(*) over(PARTITION BY club_name) cnt
	FROM
	tr_football_league
)
,CTE2 AS
(
	SELECT a.club_name,COUNT(a.cnt) Maxy FROM CTE a INNER JOIN tr_football_league b ON a.club_name = b.club_name
	WHERE b.year_100th_champion = 1
	GROUP BY a.club_name
)
SELECT club_name FROM CTE2
WHERE Maxy = (SELECT MAX(Maxy) FROM CTE2)

---------------------------------------
--Sol 2
---------------------------------------


SELECT club_name FROM 
(
      SELECT club_name, ROW_NUMBER() OVER (ORDER BY counts desc) ranker
      FROM
      (
            SELECT club_name, max(cnt) counts
            FROM
            (
                  SELECT club_name,
                  year_100th_champion,
                  COUNT(*) over(PARTITION BY club_name) cnt
                  FROM
                  tr_football_league
            ) a
            GROUP BY club_name
            HAVING SUM(year_100th_champion) > 0  
      ) art
) r WHERE ranker = 1




--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

http://MSBISkills.com

T-SQL Query | [ The Fishbone Salary Puzzle ]

26 Thursday Mar 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 3 Comments

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL pl/sql puzzles, SQL Puzzles, SQL SERVER Interview questions, SQL SERVER2005/2008, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ The Fishbone Salary Puzzle ]  – In this puzzle we have to find which employee is getting salary hikes across different months in a fishbone structure. Please check out the sample input and expected output for details.

Sample Input

emp_name sal_date sal_amt
Dick 20-06-1996 500
Harry 20-07-1996 500
Harry 20-09-1996 700
Tom 20-06-1996 500
Tom 20-08-1996 700
Tom 20-10-1996 800
Tom 20-12-1996 900

Expected Output

emp_name 20-06-1996 20-07-1996 20-08-1996 20-09-1996 20-10-1996 20-12-1996
Dick 500 NULL NULL NULL NULL NULL
Harry NULL 500 NULL 700 NULL NULL
Tom 500 NULL 700 NULL 800 900

Rules/Restrictions

  • The solution should be should use “SELECT” statement or “CTE”.
  • Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script

Use the below script to generate the source table and fill them up with the sample data.


--Create Table

CREATE TABLE Salaries
(emp_name CHAR(10) NOT NULL,
sal_date DATE NOT NULL,
sal_amt DECIMAL (8,2) NOT NULL,
PRIMARY KEY (emp_name, sal_date));

--Insert Data
INSERT INTO Salaries
VALUES ('Tom', '1996-06-20', 500.00),
('Tom', '1996-08-20', 700.00),
('Tom', '1996-10-20', 800.00),
('Tom', '1996-12-20', 900.00),
('Dick', '1996-06-20', 500.00),
('Harry', '1996-07-20', 500.00),
('Harry', '1996-09-20', 700.00);

--Verify Data
SELECT * FROM Salaries

Update May 14 | Solution


--

/************   SOLUTION 1    | Pawan Kumar Khowal     ****************/

SELECT Emp_Name,[1996-06-20],[1996-07-20],[1996-08-20],[1996-09-20],[1996-10-20],[1996-12-20] 
FROM Salaries
PIVOT 
(
	MAX(sal_amt) FOR sal_date IN ([1996-06-20],[1996-07-20],[1996-08-20],[1996-09-20],[1996-10-20],[1996-12-20])
)p



--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

http://MSBISkills.com

T-SQL Query | [ The Double Join Puzzle ]

26 Thursday Mar 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 1 Comment

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL pl/sql puzzles, SQL Puzzles, SQL SERVER Interview questions, SQL SERVER2005/2008, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ The Double Join Puzzle ]  – In this puzzle we have to join below 3 input tables and get the desired output. Please check out the sample input and expected output for details.

Sample Input

EmployeeDlts

ID Name
1 Pawan
2 Neeraj
3 Isha

EmployeeProject

1 Microsoft
1 Google
1 HortonWorks
2 Microsoft

EmployeeSkills

ID Skill
1 SQL
1 MSBI
2 SQL
2 SSRS

Expected Output

Id Name Project Skill
1 Pawan Microsoft SQL
1 Pawan Google MSBI
1 Pawan HortonWorks NULL
2 Neeraj Microsoft SQL
2 Neeraj NULL SSRS

Rules/Restrictions

  • The solution should be should use “SELECT” statement or “CTE”.
  • Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script

Use the below script to generate the source table and fill them up with the sample data.


CREATE TABLE EmployeeDlts(
ID INT,
Name VARCHAR(10)
)
GO

INSERT INTO EmployeeDlts(ID,Name)
SELECT 1,'Pawan'  UNION ALL
SELECT 2,'Neeraj' UNION ALL
SELECT 3,'Isha'
GO

CREATE TABLE EmployeeSkills(
ID INT,
Skill VARCHAR(10)
)
GO

INSERT INTO EmployeeSkills(ID,Skill)
SELECT 1,'SQL'  UNION ALL
SELECT 1,'MSBI'  UNION ALL
SELECT 2,'SQL' UNION ALL
SELECT 2,'SSRS'

CREATE TABLE EmployeeProject(
ID INT,
Project VARCHAR(15)
)
GO

INSERT INTO EmployeeProject(ID,Project)
SELECT 1,'Microsoft'  UNION ALL
SELECT 1,'Google'  UNION ALL
SELECT 1,'HortonWorks' UNION ALL
SELECT 2,'Microsoft'

Update May 14 | Solution


--

/************   SOLUTION 1    | Pawan Kumar Khowal     ****************/



;WITH CTE1 AS
(
	SELECT * , ROW_NUMBER() OVER (PARTITION BY ID ORDER BY %%Physloc%%) rnk FROM EmployeeSkills s 
)
,CTE2 AS 
(
	SELECT * , ROW_NUMBER() OVER (PARTITION BY ID ORDER BY %%Physloc%%) rnk FROM EmployeeProject p 
)
SELECT ISNULL(a.ID,b.Id) Id, d.Name , b.Project, a.Skill  FROM CTE1 a FULL OUTER JOIN CTE2 b ON a.ID = b.ID AND a.rnk = b.rnk 
LEFT JOIN EmployeeDlts d ON d.ID = ISNULL(a.ID,b.ID)


--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

http://MSBISkills.com

T-SQL Query | [ The Manager employee hierarchy Puzzle ]

26 Thursday Mar 2015

Posted by Pawan Kumar Khowal in SQL SERVER, T SQL Puzzles

≈ 3 Comments

Tags

Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL pl/sql puzzles, SQL Puzzles, SQL SERVER Interview questions, SQL SERVER2005/2008, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries


T-SQL Query | [ The Manager employee hierarchy Puzzle ]  – In this puzzle we have to find employees their managers with their hierarchy. Please check out the sample input and expected output for details.

Sample Input

EmpID EmpName ReportsTo
1 Jacob NULL
2 Rui NULL
3 Jacobson NULL
4 Jess 1
5 Steve 1
6 Bob 1
7 Smith 2
8 Bobbey 2
9 Steffi 3
10 Bracha 3
11 John 5
12 Michael 6
13 Paul 6
14 Lana 7
15 Johnson 7
16 Mic 8
17 Stev 8
18 Paulson 9
19 Jessica 10

Expected Output

Hierarchy Hierarchy EmpName EmpId Level FullyQualifiedName
Jacob 1 Jacob 1 0 .Jacob.
    Bob 6 Bob 6 1 .Jacob..Bob.
        Michael 12 Michael 12 2 .Jacob..Bob..Michael.
        Paul 13 Paul 13 2 .Jacob..Bob..Paul.
    Jess 4 Jess 4 1 .Jacob..Jess.
    Steve 5 Steve 5 1 .Jacob..Steve.
        John 11 John 11 2 .Jacob..Steve..John.
Jacobson 3 Jacobson 3 0 .Jacobson.
    Bracha 10 Bracha 10 1 .Jacobson..Bracha.
        Jessica 19 Jessica 19 2 .Jacobson..Bracha..Jessica.
    Steffi 9 Steffi 9 1 .Jacobson..Steffi.
        Paulson 18 Paulson 18 2 .Jacobson..Steffi..Paulson.
Rui 2 Rui 2 0 .Rui.
    Bobbey 8 Bobbey 8 1 .Rui..Bobbey.
        Mic 16 Mic 16 2 .Rui..Bobbey..Mic.
        Stev 17 Stev 17 2 .Rui..Bobbey..Stev.
    Smith 7 Smith 7 1 .Rui..Smith.
        Johnson 15 Johnson 15 2 .Rui..Smith..Johnson.
        Lana 14 Lana 14 2 .Rui..Smith..Lana.

Rules/Restrictions

  • The solution should be should use “SELECT” statement or “CTE”.
  • Add your solution(s) in the comments section or send you solution(s) to pawankkmr@gmail.com

Script

Use the below script to generate the source table and fill them up with the sample data.

--Create Table

CREATE TABLE Employees  (EmpID INT, EmpName VARCHAR(20), ReportsTo INT)

--Insert Data
INSERT INTO Employees(EmpID, EmpName, ReportsTo)
SELECT 1, 'Jacob', NULL UNION ALL
SELECT 2, 'Rui', NULL UNION ALL
SELECT 3, 'Jacobson', NULL UNION ALL
SELECT 4, 'Jess', 1 UNION ALL
SELECT 5, 'Steve', 1 UNION ALL
SELECT 6, 'Bob', 1 UNION ALL
SELECT 7, 'Smith', 2 UNION ALL
SELECT 8, 'Bobbey', 2 UNION ALL
SELECT 9, 'Steffi', 3 UNION ALL
SELECT 10, 'Bracha', 3 UNION ALL
SELECT 11, 'John', 5 UNION ALL
SELECT 12, 'Michael', 6 UNION ALL
SELECT 13, 'Paul', 6 UNION ALL
SELECT 14, 'Lana', 7 UNION ALL
SELECT 15, 'Johnson', 7 UNION ALL
SELECT 16, 'Mic', 8 UNION ALL
SELECT 17, 'Stev', 8 UNION ALL
SELECT 18, 'Paulson', 9 UNION ALL
SELECT 19, 'Jessica', 10

--Verify Data
SELECT * FROM Employees E

UPDATE – 24-Apr-2015 – Solution 1


--

;WITH CTE(EmpName , EmpId, Level,FullyQualifiedName) AS (
     Select E.EmpName, E.EmpID, 0 Level
     , Cast('.'+E.EmpName+'.' as Varchar(MAX)) FullyQualifiedName         
     From Employees E Where E.ReportsTo IS NULL
     UNION ALL
     Select E.EmpName, E.EmpID, c.Level + 1 , c.FullyQualifiedName+'.'+E.EmpName+'.' FullyQualifiedName  
     From Employees E INNER JOIN CTE c on c.EmpID = e.ReportsTo 
)
SELECT SPACE(LEVEL*4) + H.EmpName Hierarchy,SPACE(LEVEL*4) + CAST(H.EmpID AS VARCHAR(MAX)) Hierarchy , * FROM CTE H 
ORDER BY H.FullyQualifiedName
`
--

Add a comment if you have any other solution in mind. We all need to learn.

Keep Learning

http://MSBISkills.com

← Older posts

Blog Stats

  • 1,074,528 hits

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,131 other subscribers

Pawan Khowal

502 SQL Puzzles with answers

Achievement - 500 PuzzlesJuly 18, 2018
The big day is here. Finally presented 500+ puzzles for SQL community.

200 SQL Server Puzzle with Answers

The Big DayAugust 19, 2016
The big day is here. Completed 200 SQL Puzzles today

Archives

March 2015
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Nov   Apr »

Top Articles

  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…
  • pawankkmr.wordpress.com/2…

Archives

  • October 2020 (29)
  • September 2018 (2)
  • August 2018 (6)
  • July 2018 (25)
  • June 2018 (22)
  • May 2018 (24)
  • April 2018 (33)
  • March 2018 (35)
  • February 2018 (53)
  • January 2018 (48)
  • December 2017 (32)
  • November 2017 (2)
  • October 2017 (20)
  • August 2017 (8)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (18)
  • January 2017 (2)
  • December 2016 (5)
  • November 2016 (23)
  • October 2016 (2)
  • September 2016 (14)
  • August 2016 (6)
  • July 2016 (22)
  • June 2016 (27)
  • May 2016 (15)
  • April 2016 (7)
  • March 2016 (5)
  • February 2016 (7)
  • December 2015 (4)
  • October 2015 (23)
  • September 2015 (31)
  • August 2015 (14)
  • July 2015 (16)
  • June 2015 (29)
  • May 2015 (25)
  • April 2015 (44)
  • March 2015 (47)
  • November 2012 (1)
  • July 2012 (8)
  • September 2010 (26)
  • August 2010 (125)
  • July 2010 (2)

Article Categories

  • Analysis Services (6)
    • DAX (6)
  • Data (2)
    • Data warehousing (2)
  • Integration Services (2)
  • Magazines (3)
  • Python (29)
  • Reporting Services (4)
  • SQL SERVER (820)
    • Download SQL Interview Q's (212)
    • SQL Concepts (323)
    • SQL Performance Tuning (155)
    • SQL Puzzles (331)
    • SQL SERVER 2017 Linux (6)
    • SQL Server Interview Questions (308)
    • SQL SERVER Puzzles (332)
    • T SQL Puzzles (547)
    • Tricky SQL Queries (439)
  • UI (30)
    • ASP.NET (5)
    • C# (13)
    • CSS (9)
    • OOPS (3)
  • Uncategorized (5)

Recent Posts

  • Python | The Print and Divide Puzzle October 30, 2020
  • Python | Count consecutive 1’s from a list of 0’s and 1’s October 30, 2020
  • Python | How to convert a number into a list of its digits October 26, 2020
  • Python | Validate an IP Address-IPV6(Internet Protocol version 6) October 26, 2020
  • Python | Print the first non-recurring element in a list October 26, 2020
  • Python | Print the most recurring element in a list October 26, 2020
  • Python | Find the cumulative sum of elements in a list October 26, 2020
  • Python | Check a character is present in a string or not October 26, 2020
  • Python | Check whether a string is palindrome or not October 26, 2020
  • Python | Find the missing number in the array of Ints October 26, 2020
  • Python | How would you delete duplicates in a list October 26, 2020
  • Python | Check whether an array is Monotonic or not October 26, 2020
  • Python | Check whether a number is prime or not October 26, 2020
  • Python | Print list of prime numbers up to a number October 26, 2020
  • Python | Print elements from odd positions in a list October 26, 2020
  • Python | Print positions of a string present in another string October 26, 2020
  • Python | How to sort an array in ascending order October 26, 2020
  • Python | How to reverse an array October 26, 2020
  • Python | Find un-common words from two strings October 26, 2020
  • Python | How to convert a string to a list October 26, 2020
  • Python | Find unique words from a string October 26, 2020
  • Python | Calculate average word length from a string October 26, 2020
  • Python | Find common words from two strings October 26, 2020
  • Python | Find the number of times a substring present in a string October 26, 2020
  • Python | Find maximum value from a list October 26, 2020
  • Python | How to find GCF of two numbers October 26, 2020
  • Python | How to find LCM of two numbers October 26, 2020
  • Python | How to convert a list to a string October 26, 2020
  • Python | Replace NONE by its previous NON None value October 26, 2020
  • Microsoft SQL Server 2019 | Features added to SQL Server on Linux September 26, 2018

Create a website or blog at WordPress.com

  • Follow Following
    • Improving my SQL BI Skills
    • Join 231 other followers
    • Already have a WordPress.com account? Log in now.
    • Improving my SQL BI Skills
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar