Tags

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


SQL PUZZLE | Can you get Records with at least 6 characters and maximum 10 characters ? | SQL Interview Question

In this puzzle you have to get records with at least 6 characters and maximum 10 characters. Please see the sample input and expected output.

Sample Input

Id Vals
1 11111111
2 123456
2 1234567
2 1234567890
5
6 NULL
7 123456789012345

Expected Output

Id Vals
1 11111111
2 123456
2 1234567
2 1234567890

Script – DDL and INSERT Sample Data

--

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

INSERT INTO TestFixLengths VALUES
(1,'11111111'),
(2,'123456'),
(2,'1234567'),
(2,'1234567890'),
(5,''),
(6,NULL),
(7,'123456789012345')
GO

SELECT * FROM TestFixLengths
GO

--

SOLUTION – 1

--

SELECT * FROM TestFixLengths
WHERE LEN(Vals) >= 6 AND LEN(Vals) <= 10 
GO

--

Output – 1

--

Id          Vals
----------- -------------------
1           11111111
2           123456
2           1234567
2           1234567890

(4 rows affected)

--

SOLUTION – 2

--

SELECT * FROM TestFixLengths
WHERE LEN(Vals) BETWEEN 6 AND 10 
GO

--

Output – 2

--

Id          Vals
----------- -------------------
1           11111111
2           123456
2           1234567
2           1234567890

(4 rows affected)

--

SOLUTION – 3

--

SELECT * FROM TestFixLengths
WHERE DATALENGTH(Vals) BETWEEN 6 AND 10 
GO

--

Output – 3

--

Id          Vals
----------- -------------------
1           11111111
2           123456
2           1234567
2           1234567890

(4 rows affected)

--

Enjoy 🙂

Please add comment(s) if you have one or multiple solutions in mind. Thank You.

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