Tags

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


SQL Puzzle | Search Capital Letters ONLY Puzzle ? | SQL Interview Question

In this puzzle you have to search captial P only from the vals column.

Please check the sample input and the expected output.

Sample Input

Id Vals
1 Pawan
2 PAWAN
3 pawaK
4 pawa
5 PawanKhowal
6 paw
7 pAW

Expected Output

Id Vals
1 Pawan
2 PAWAN
5 PawanKhowal

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

--

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

INSERT INTO SearchCapitalLettersOnly VALUES
(1,'Pawan'),
(2,'PAWAN'),
(3,'pawaK'),
(4,'pawa'),
(5,'PawanKhowal'),
(6,'paw'),
(7,'pAW')
GO

SELECT * FROM SearchCapitalLettersOnly
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 * FROM SearchCapitalLettersOnly
WHERE Vals LIKE 'P%' COLLATE Latin1_General_Bin
GO

--

Output-1

--                            


Id          Vals
----------- ---------------------------
1           Pawan
2           PAWAN
5           PawanKhowal

(3 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.

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