• 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: February 8, 2018

SQL Puzzle | GET ISNULL ( ISNULL ( Next NON NULL Value, Previous NON NULL Value ) ,0 ) Puzzle

08 Thursday Feb 2018

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

≈ 3 Comments


SQL Puzzle | GET ISNULL(ISNULL( Next NON NULL Value, Previous NON NULL Value),0) Puzzle

In this puzzle you have to replace the null values with the non null values based on the following conditions.

1. Replace the null value with the next non null value if present.
2. If there is no next non null value then replace the null value with the previous non null value if present.
3. If there is no previous non null value and no next non null value then replace the null value with 0.
4. For more details please check the sample input and expected output.

Sample Input

Code Id Vals
1001 1 1000
1001 2 NULL
1001 3 NULL
1001 4 4000
1002 1 NULL
1002 2 2000
1002 3 3000
1002 4 NULL
1003 1 1210
1003 2 NULL
1004 1 NULL

Expected Output

code Id Vals
1001 1 1000
1001 2 4000
1001 3 4000
1001 4 4000
1002 1 2000
1002 2 2000
1002 3 3000
1002 4 3000
1003 1 1210
1003 2 1210
1004 1 0

Script

Use below script to create table and insert sample data into it.

--

CREATE TABLE FillNullData
(
     Code INT
    ,Id INT
    ,Vals INT
)

INSERT INTO FillNullData VALUES
(1001,1,1000),
(1001,2,NULL),
(1001,3,NULL),
(1001,4,4000),
(1002,1,NULL),
(1002,2,2000),
(1002,3,3000),
(1002,4,NULL),
(1003,1,1210),
(1003,2,NULL),
(1004,1,NULL)

SELECT * FROM FillNullData
GO


--

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

SOLUTION – 1

--


SELECT a.code,a.Id,COALESCE(a.Vals,z.Vals,z1.Vals,0) Vals 
FROM FillNullData a
OUTER APPLY 
(
	SELECT TOP 1 Vals
	FROM FillNullData b
	WHERE a.code = b.code
	AND b.Vals IS NOT NULL AND a.Id <b Id> b.Id
	ORDER BY Id DESC
)z1


--

Output-1

--                            

code        Id          Vals
----------- ----------- -----------
1001        1           1000
1001        2           4000
1001        3           4000
1001        4           4000
1002        1           2000
1002        2           2000
1002        3           3000
1002        4           3000
1003        1           1210
1003        2           1210
1004        1           0

(11 rows affected)

--

SOLUTION by Vaibhav Goel

--


;WITH CTE AS 
(
	SELECT * 
		   ,SUM(CASE WHEN vals IS NULL THEN 0 ELSE 1 END) OVER (PARTITION BY code ORDER BY ID DESC) g1
		   ,SUM(CASE WHEN vals IS NULL THEN 0 ELSE 1 END) OVER (PARTITION BY code ORDER BY ID ASC) g2
	FROM FillNullData
)
,CTE1 AS 
(
   SELECT *  
          ,MAX(vals) OVER (PARTITION BY code, g1) AS vals1
		  ,MAX(vals) OVER (PARTITION BY code, g2) AS vals2
   FROM CTE
)
SELECT code,Id,COALESCE(vals,Vals1,Vals2,0) Vals FROM CTE1
ORDER By code,Id


--

Output

--                            

code        Id          Vals
----------- ----------- -----------
1001        1           1000
1001        2           4000
1001        3           4000
1001        4           4000
1002        1           2000
1002        2           2000
1002        3           3000
1002        4           3000
1003        1           1210
1003        2           1210
1004        1           0
Warning: Null value is eliminated by an aggregate or other SET operation.

(11 rows affected)

--

Add a comment if you have any other or better solution in mind. I would love to learn it. We all need to learn.

Author – Pawan Khowal

Pawan is a SQL Server Expert. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Like this:

Like Loading...

SQL Server Interview Questions & Answers – SET 12(10 Questions & Answers)

08 Thursday Feb 2018

Posted by Pawan Kumar Khowal in Download SQL Interview Q's, SQL Performance Tuning, SQL SERVER, SQL Server Interview Questions

≈ 2 Comments

Tags

Advanced SQL Interview Questions and Answers, Advanced SQL tutorial pdf, any recommended websites for sql puzzles, Best SQL Puzzles, Buy SQL Server Interview Questions Book Online at Low Price, COmples tSQL puzzles, Complex SQL Challenges, complex sql statement(puzzle), Complex tsql, Complex TSQL Challenge, convert string to proper case in sql server, Divide rows into two columns, Download SQL Questions, Download SQL Server Interview Question in PDF, Download SQL SERVER Interview questions, Download SQL Server Interview questions and answers, download sql server interview questions and answers pdf, download sql server interview questions by Pawan Khowal, download sql server interview questions by Pawan Kumar, download sql server interview questions by Pawan Kumar Khowal, Download T-SQL Interview Questions, Free Download SQL SERVER Interview questions, Get Next Value Puzzle, Huge blank areas in database field, Improve SQL Skills, Interview Puzzles in SQL Server, Interview Qs.SQL SERVER Questions, Interview questions and Answers for MS SQL Server designing, Interview Questions and Answers For SQL, Interview questions on Joins, Interview Questions on SQL, Interview SQL Puzzles, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, Microsoft SQL Server interview questions for DBA, MS SQL Server interview questions, MSBI Interview Questions, Objective Puzzle, Pawan, Pawan Khowal, Pawan Kumar, Pawan Kumar Khowal, PL/SQL Challenges, Puzzle SQL, puzzle sql developer, Puzzle SQl Server, Puzzles, PUzzles in SQL SERVER, Queries for SQL Interview, Remove Huge Multiple Spaces from a DB Fields, Remove Multiple Spaces from a DB Fields, Separate Int and char from a string column, Single Quote update SQL, SQL, SQL - The Pattern Puzzles, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Extreme Difficult Puzzle, SQL FAQ, SQL FAQs, sql group by only rows which are in sequence, SQL Interview Q & A, SQL Interview Questions, SQL Interview Questions - Part 2, SQL Interview Questions for SQL Professionals‎, SQL Joins, SQL Pattern Puzzles, SQL pl/sql puzzles, SQL prime number puzzle, SQL puzzle, SQL Puzzles, sql puzzles & answers, sql puzzles and answers free download, sql puzzles and answers pdf, sql puzzles for interview, sql puzzles oracle, SQL Queries, SQL Queries asked in interviews, SQL QUERY PUZZLES, SQL Query to Find Nth Highest Salary of Employee, SQL Questions, SQL Quiz, SQL Replace Puzzle, SQL Server - Common Interview Questions and Answers, SQL SERVER - Find Nth Highest Salary of Employee, SQL Server - General Interview Questions and Answers, sql server 2008 interview questions, SQL Server 2008 Interview Questions and Answers, SQL Server Database, SQL Server database developer interview questions and answers, sql server dba interview questions, SQL Server developer Interview questions and answers, SQL Server developer Interview questions with answers, SQL Server Developer T-SQL Interview Questions, SQL server filter index with LIKE and RIGHT function?, SQL Server Interview Puzzle, SQL SERVER Interview questions, SQL SERVER Interview questions & Answers, SQL Server Interview Questions - Part 1, SQL Server Interview questions and answers, SQL Server Interview Questions and Answers - Free PDF, SQL SERVER Interview questions and answers for experienced, sql server interview questions and answers for net developers, SQL Server Interview Questions And Answers.pdf, sql server interview questions by Pawan Khowal sql interview questions, SQL SERVER Interview questions pdf, SQL Server Interview Questions | MSBISKILLS.Com, SQL Server Interview Questions | MSBISKILLS.com Top 50 SQL Server Questions & Answers, SQL Server Interview Questions/Answers Part-1, SQL Server Puzzle, SQL SERVER Puzzles, SQL server Questions and Answers, SQL SERVER Tips, SQL Skills, SQL Sudoku, SQL Tips & Tricks, SQL Tips and Tricks, SQL Top clause, SQL Tough Puzzle, SQL Tricks, SQL Trikcy question, sql/database interview for puzzle sql developer, SQLBI Interview Questions, SQLSERVER, SUM of grouped COUNT in SQL Query, T SQL Puzzles, T-SQL Challenge, T-SQL Interview Questions | SQL Server Interviews and Jobs, T-SQL Puzzle, T-SQL Server Interview Questions, T-SQL Tricky Puzzles, The Status Puzzle, Top 10 Frequently Asked SQL Query Interview Questions, TOP 100 SQL SERVER INTERVIEW QUESTIONS QUERIES, Top 50 SQL Server Interview Question for Testers, Tough SQL Challenges, Tough SQL Puzzles, Tricky Questions, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Puzzle, TSQL Puzzles, TSQL Queries


SQL Server Interview Questions & Answers – SET 12(10 Questions & Answers)

1. Why is extra comma giving error while declaring table variable and not for create table command?

Example – 1

--

E.g. 
CREATE TABLE a234 ( Id Int , )

OUTPUT
Commands completed successfully.

--

Example – 1

--                            

DECLARE @a234  TABLE ( Id INT , )

OUTPUT 

Msg 156, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'TABLE'.

--

Ans:-

Consider this as bug. Please check out what MS said about this- “This was resolved some time ago as “won’t fix” but we didn’t explain why. Simply, this seems pretty harmless, and not worth fixing in a service pack. We may consider fixing this in a future release.”

2. How you can move tempdb and templog to another drive?

Ans:-

Execute the below commands:

--                            

ALTER DATABASE tempDB 
	MODIFY FILE ( NAME = tempdev, FILENAME = 'Newpath........\tempDB\data\tempdb.mdf' )
GO

ALTER DATABASE tempDB 
	MODIFY FILE ( NAME = templog, FILENAME = 'Newpath........\tempDB\log\templog.ldf' )
GO

--

Note – After executing the above commands you need to stop and start SQL Server.

3. Can shrinking the .ldf file will cause fragmentation?

Ans:-

No it will not. The log file is sequential and can’t be fragmented. Also note that you should use only one log file as multiple
log files would only be used sequentially anyway.

4. Should we provide SQL Server file Autogrowth say 2 MB or should be provide that in percentage?

Ans:-

A fixed amount of Autogrowth is good. But 2MB is very low and bad. We should the increase the size to 64MB. It should be good enough for most databases.

Note – Do not ever use % growth on any file. Always use fixed value.

5. How you can prevent the usage of SELECT * from a table?

Ans:-

In this case you need to follow the steps below-

1. Create a view like below-

--                            

SELECT * ,  CAST('a' AS INT) aaerrror
FROM yourTableName

--

2. Remove SELECT access from your table i.e. yourTableName

3. GRANT SELECT permission to the new view created.

Sample:-

--                            

Create TABLE test
(
	 Id INT
	,Val Varchar(10)
)
GO

INSERT INTO test VALUES ( 1 , 'a' ) , (2 , 'b')
GO

--

Create View

--                            

CREATE VIEW Vwtest
AS
SELECT * ,  CAST('a' AS INT) aaerrror
FROM test

--

So when the user execute the select * from Vwtest they will recieve the error. See example below-

--                            

SELECT * FROM Vwtest

Output

Msg 245, Level 16, State 1, Line 87
Conversion failed when converting the varchar value 'a' to data type int.

--

But when you will provide the column names you will get proper output. Check below.

--                            

SELECT id,val FROM VWTest

OUTPUT

id          val
----------- ----------
1           a
2           b

(2 rows affected)

--

6. Can users access database in Read-Only mode?

Ans:-

Yes they can but they would not be able to make changes to the database. Meaning DDL (creating, modifying or removing objects) or DML that modifies the data in the database (inserts, updates or deletes) are not allowed.

7. What is the difference between lock and deadlock?

Ans:-

From Microsoft – When multiple users or applications access the same data at the same time, locking prevents them from making simultaneous changes to the data. Locks are managed internally by the Microsoft SQL Server Compact Database Engine. The locks are automatically acquired and released based on actions taken by the user.

It’s normal for tasks to sometimes have to wait for locks to clear. It’s called “blocking”, and again, it’s perfectly normal.

Read more from – https://technet.microsoft.com/en-us/library/ms172975(v=sql.110).aspx

A deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock.

In that case, SQL is forced to kill all but one of the deadlocked tasks.

Read more from – https://technet.microsoft.com/en-us/library/ms178104(v=sql.105).aspx

8. What are the immediate steps your one should take as a DBA if your database is down suddenly?

Ans:-

I am not a DBA but you can start by checking logs – Windows Event Log and SQL Server Error Log for error entries. Then you need to bring the server and the SQL Server instance online.

9. My Query is using LOOP JOIN and it is very slow? What should I do?

Ans:-

Well in this case you can use JOIN hint ( Read more from – https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-join ). A LOOP JOIN can be very costly in cases where the optimizer’s row estimation is incorrect. If the number of input tables are high and the query is complex then it is more likely that SQL is to mis-estimate the number of rows.

I would recommend to use below.

--                            

OPTION ( HASH JOIN, MERGE JOIN )

--

This will allows SQL to decide either a MERGE or a HASH JOIN is used, depending on which will perform better. Note when you mention this SQL will eliminate the LOOP join.

Other option you can do is to provide the JOIN explicitly like INNER HASH JOIN.

Also note that more details can only be shared depending on what execution plan your query has.

10. Should we install SQL Server engine on a dedicated server or NOT?

Ans:-

SQL Server engine should be installed on a dedicated server. Also do not install anything on this server but SSMS.

Note – Since this is the most important server so we will have to keep it the clean with very less people touching it.

Author Introduction: Pawan Khowal

Pawan is a SQL Server Expert. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

SQL Puzzle | Find Minimum Value from Multiple Columns Puzzle

08 Thursday Feb 2018

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

≈ Leave a comment


SQL Puzzle | Find Minimum Value from Multiple Columns Puzzle

In this puzzle you have to find minimum value from multiple columns other than the NULL and zero value. For more details please check the sample input and expected output.

Sample Input

Id a b c d e f
1 NULL 0 918.09 162.12 NULL 675.72
2 NULL 0 761.09 19.12 NULL 231.72

Expected Output

Id MinimumValue
1 162.12
2 19.12

Script

Use below script to create table and insert sample data into it.

--

CREATE TABLE FindMinimumNotNULL
(
	 Id INT
	,a INT
	,b INT 
	,c DECIMAL(10,2)
	,d DECIMAL(10,2)
	,e INT
	,f DECIMAL(10,2)
)
GO

INSERT INTO FindMinimumNotNULL (Id,a,b,c,d,e,f) Values 
(1,NULL,0,918.09,162.12,NULL,675.72),
(2,NULL,0,761.09,19.12,NULL,231.72)
GO

SELECT * FROM FindMinimumNotNULL
GO

--

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

Solution – 1 | USING VALUES

--


SELECT Id,
(
       SELECT MIN(v)
       FROM 
	   (
          VALUES (a) , (b), (c) ,(d) ,(e) , (f) 
       ) as value(v)
	   WHERE v > 0
) as MinimumValue 
FROM FindMinimumNotNULL 

--

Output-1

--                            

Id          MinimumValue
----------- ---------------------------------------
1           162.12
2           19.12

(2 rows affected)

--

Solution – 2 | USING UNPIVOT METHOD

--


SELECT Id,MIN(mmin) MinimumValue
FROM 
(
    SELECT Id,CAST(a AS DECIMAL(10,2)) a 
    ,CAST(b AS DECIMAL(10,2)) b 
	,CAST(c AS DECIMAL(10,2)) c
	,CAST(d AS DECIMAL(10,2)) d 
	,CAST(e AS DECIMAL(10,2)) e
	,CAST(f AS DECIMAL(10,2)) f
    FROM FindMinimumNotNULL
) t
UNPIVOT (mmin FOR vals IN (a,b,c,d,e,f)) u
WHERE mmin > 0
GROUP BY Id

--

Output-2

--                            

Id          MinimumValue
----------- ---------------------------------------
1           162.12
2           19.12

(2 rows affected)

--

Related Puzzle

SQL Puzzle URL
Finding Maximum Value from multiple columns Puzzle https://msbiskills.com/2015/03/19/310/

Add a comment if you have any other or better solution in mind. I would love to learn it. We all need to learn.

Author Introduction: Pawan Khowal

Pawan is a SQL Server Expert. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Share this

  • LinkedIn
  • Facebook
  • Twitter
  • WhatsApp
  • Email

Blog Stats

  • 1,074,977 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

February 2018
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728  
« Jan   Mar »

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
%d bloggers like this: