Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


SQL Puzzle | Only 2 digits between alphabets puzzle | SQL Server Interview Question

In this puzzle you have to get records where you have 2 digits between the alphabetical characters. So as per the below data you should get only first record as the output. Please check the sample input and the expected output.

Notes –
1. The limitation is that we can only use a single SELECT for the puzzle.

Sample Input

Id Vals
1 A11A
2 A1A
3 A123A
4 1
5 A0A
6 NULL
7 1A1
8 11A11
9 A2
10 2A

Expected Output

Id Vals
1 A11A

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

--

CREATE TABLE GetRecordswithDoubleDigitOnly
(
	 Id INT 
	,Vals VARCHAR(100)
)
GO

INSERT INTO GetRecordswithDoubleDigitOnly
SELECT 1,'A11A' UNION ALL
SELECT 2,'A1A' UNION ALL
SELECT 3,'A123A' UNION ALL
SELECT 4,'1' UNION ALL
SELECT 5,'A0A' UNION ALL
SELECT 6,NULL UNION ALL
SELECT 7,'1A1' UNION ALL
SELECT 8,'11A11' UNION ALL
SELECT 9,'A2' UNION ALL
SELECT 10,'2A'
GO

SELECT * FROM GetRecordswithDoubleDigitOnly
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 | This solution was given by my friend ASHUTOSH

--



SELECT * FROM GetRecordswithDoubleDigitOnly
WHERE Vals LIKE '%[a-z][0-9][0-9][a-z]%'

--

Output-1

--                            

Id          Vals
----------- -----------
1           A11A

(1 row 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.

Pawan Khowal

Pawan is a SQL Server Developer. 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

Advertisements