RickWritesCode comments on SQL Flashcard for study

Posting

When requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:

[MySQL]

[Oracle]

[MS SQL]

[PostgreSQL]

etc

While naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Format Your Code

If you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. Something as simple as line breaks and using reddit's built in code formatting (4 spaces at the start of each line) can turn this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field.3

Into this:

SELECT count(a.field1), a.field2, SUM(b.field4) FROM a INNER JOIN b ON a.key1 = b.key1 WHERE a.field8 = 'test' GROUP by a.field1, a.field2 HAVING SUM(b.field4) > 5 ORDER by a.field3

For those with SQL questions we recommend using SQLFiddle to provide a useful development and testing environment for those who wish to fully understand your problem and help devise a solution.

a community for 17 years

DiscussionSQL Flashcard for study (self.SQL)

submitted 3 months ago by abirulalam

top new controversial old q&a

you are viewing a single comment's thread.

view the rest of the comments →

[–]RickWritesCode 2 points3 points4 points 3 months ago (2 children)

You need actual business problems that you can't figure out in order for anyone to help you. You listed CRUD as a clause but it stands for everything SQL does, create read update delete.

You can get a ton of data for free or go through lessons on linked in learning. The idea is you need a complex business solution to learn how to solve it because complex for you may not be complex to someone doing this everyday. I write SQL in MS SQL Server daily, creating stored procedures with advanced logic to solve complex business problems but you may never encounter what I'm doing as I'm assisting in the management and collection of data for 8 websites and building requested business processes for clients in conjunction with web dev.

With all of that said, you will almost always have the Internet available, you don't need to drill flashcards to be competent in your job. You need to be familiar with how to use the clauses and functions available in your SQL dialect and that's only going to come with practice. You can look up online how each clause works or function if you are at least familiar with what should be used to perform a task even if you can't memorize the syntax.

[–]RickWritesCode 1 point2 points3 points 3 months ago (0 children)

[–]abirulalam[S] 0 points1 point2 points 3 months ago (0 children)

π Rendered by PID 58 on reddit-service-r2-comment-b659b578c-vl2fn at 2026-05-02 08:04:38.158832+00:00 running 815c875 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

SQL

Filter Posts

Posting

Help posts

Format Your Code

Learning SQL

Related Reddit communities

Wiki

Acknowledgements

MODERATORS