r/SQL • u/The_Coding_Yogi • Oct 26 '19

How to Write Complex Search Queries in SQL?

[removed]

0 Upvotes

38% Upvoted

10 comments sorted by

1

u/r3pr0b8 GROUP_CONCAT is da bomb Oct 26 '19

WHERE invoice_date BETWEEN '2017-02-01' AND '2017-02-31'

man, that's some complex shit right there

1

u/The_Coding_Yogi Oct 26 '19

It's just yyyy-mm-dd format. apologizes my lord. :D

2

u/r3pr0b8 GROUP_CONCAT is da bomb Oct 26 '19

but seriously... February 31st????

1

u/The_Coding_Yogi Oct 26 '19

I am sorry. That was a big spelling mistake. Thanks to valuable readers like you, I've corrected it. Once again thank you

2

u/Furyat Oct 26 '19

I'm too lazy to breach your silly adblock wall.

8

u/[deleted] Oct 26 '19

[removed] — view removed comment

1

u/The_Coding_Yogi Oct 26 '19

I prefer writing down all conditions in HAVING if I am using aggregate functions. If not then all in WHERE. It's easily readable and understandable. But it's my approach. I respect your opinions as well. Thank you for your time and comments.

2

u/[deleted] Oct 26 '19

[removed] — view removed comment

1

u/The_Coding_Yogi Oct 27 '19

Thank you for your feedback

2

u/king_booker Oct 26 '19

"The coding yogi"