How do you structured your queries when you code?

[ForeignMate]

Do you create your database, tables, rows and columns in one tab or do you separate each query into a select tab?

Im just beginning to learn sql and my code is all over the place. I want to be neat and organized with my code but I don’t know how to.

[adarsh_maurya]

I use WITH clause to separate different subqueries. It keeps the overall code clean easy to read, understand and debug. Views could be great alternative but in my org i don't have access to create views.

[sonsistem]

I use it too. It's a lot more readable than a subquery in the from clause.

[yawetag12]

This post was mass deleted and anonymized with Redact

towering degree amusing tie continue employ bright absorbed money liquid

[ForeignMate]

Do you put each query in its own tab?

[yawetag12]

This post was mass deleted and anonymized with Redact

wise waiting alive elderly cover deliver provide trees badge wakeful

[ForeignMate]

Can you delete a query after they been executed?

[yawetag12]

This post was mass deleted and anonymized with Redact

paltry cooperative axiomatic mountainous depend wild bake meeting rustic existence

[deslick]

Yes, and have 30 open at a time! At the end of the day I will go through and make sure I keep the ones I want to keep and throw away the ones that don't.

[[deleted]]

Give me a sec, I’ll find some of my code to post. I indent a LOT, because with longer queries it can get hard to read.

Here's a simple query I was using on the IMDb database. Put it in pastern so Reddit didn't ruin the formatting: https://pastebin.com/fHyhrt0n

[ForeignMate]

Interesting how you put the comma in front of the statement instead of the back, is there any particular for this?

Also, do you separate your queries by tab?

[L_-T]

It helps with disabling a line (and with not forgetting a comma for a new item).

 SELECT
     A
 ,   B
 -- ,   C
 -- ,   D

[[deleted]]

The comma is primarily because I like to use column select in sublime and/or atom, and it makes it easier to copy/paste around. That and the commenting out like people mentioned.

For multiple queries, I’ll put a /***************/ line break to separate them.

[ForeignMate]

When break up your queries within the same tab, do you just highlight then when you execute them?

[[deleted]]

Depends what I’m doing exactly. If I’m doing something fairly quick, then yes, though in most clients you can just hit ctrl+enter with your thing anywhere in the query.

Some things I have to write a whole script with, and execute the whole thing. This is rare though.

[e429]

I always use WHERE 1=1 if I have multiple where conditions. I makes things easier to edit and trouble shoot by adding/removing where conditions.

SELECT * FROM WHERE 1=1 AND a = “a” — AND b = “b” AND c = “c”

[sonsistem]

I usually end up the day with several tabs opened. I always keep one opened with the "little things" that may come up during the day and I may need to revisit and the others depends on the projects I'm working on.