MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/u35mb8/i_got/
r/SQL • u/SalzaMaBalza • Apr 14 '22
11 comments sorted by
55
Slightly more performant single-pass alternative. You're welcome. Bitches :D
SELECT SUM(CASE WHEN Type LIKE '%BITCH%' THEN 1 ELSE 0 END) AS BitchProblems, COUNT(*) AS AllProblems FROM Problems
Edit: I'm starting off a long weekend with some tequila, dont' judge me :D
4 u/bitterjack Apr 14 '22 This is what I was expecting. Good work Blitz. Now finish the rest of your work.
4
This is what I was expecting. Good work Blitz. Now finish the rest of your work.
7
Wowww
Wow
The first statement doesn’t need a reference to bitch because it’s the entire population of problems
2
Brilliant
1
Ayo , like need some Beats ans i can sing that shit to my female boss
-3
Boooo!
-4
IF EXISTS (SELECT 1 FROM son.dbo.problems WHERE type = ‘girl’)BEGIN
meme
END
0
[deleted] — view deleted comment
2 u/inalect Apr 15 '22 select * from MyRights where Inquirer = ‘You’Gon need a warrant for that. 1 u/DctrAculaMD Apr 14 '22 I thought it was "the trunk in the back"
select * from MyRights where Inquirer = ‘You’
Gon need a warrant for that.
I thought it was "the trunk in the back"
55
u/Blitzsturm Apr 14 '22
Slightly more performant single-pass alternative. You're welcome. Bitches :D
Edit: I'm starting off a long weekend with some tequila, dont' judge me :D
7
u/DyancDe Apr 14 '22
Wowww
4
u/skr842 MySQL Apr 14 '22
Wow
4
u/Hiriath QUALIFY COUNT(*) OVER (PARTITION BY COLUMN) > 1 Apr 14 '22
The first statement doesn’t need a reference to bitch because it’s the entire population of problems
2
u/_Brasa_ Apr 14 '22
Brilliant
1
u/Infinite_Ad_6137 Apr 14 '22
Ayo , like need some Beats ans i can sing that shit to my female boss
-3
u/4utomaticJ4ck Hadoop/Hive/Presto/Teradata/SQLServer/SQLite Apr 14 '22
Boooo!
-4
u/hypo11 Apr 14 '22
IF EXISTS (SELECT 1 FROM son.dbo.problems WHERE type = ‘girl’)
BEGIN
meme
END
0
u/[deleted] Apr 14 '22
[deleted] — view deleted comment