Source: dzone.com
3 Tips to Write SQL Queries That Are Easier to Read and ModifyCategory: Database
by In general, coding improves with experience but only when you learn the art of coding like favoring composition over inheritance or coding for interface than implementation, but, unfortunately only a few developers able to master these techniques.
By the way, I expect that you are familiar with SQL and definitely know how to write queries.
Anyway, let's examine a couple of ways to write SQL query and find out which one is the best way to express intent in quick time: The mixed-case was introduced to separate keyword from column and table names like writing SELECT in a capital case and writing Employee in as it is, but given you are not consistent like SELECT is in caps but from is in small, there is no benefit of using that style.
Which SQL style are you using?
By the way, I expect that you are familiar with SQL and definitely know how to write queries.
Anyway, let's examine a couple of ways to write SQL query and find out which one is the best way to express intent in quick time: The mixed-case was introduced to separate keyword from column and table names like writing SELECT in a capital case and writing Employee in as it is, but given you are not consistent like SELECT is in caps but from is in small, there is no benefit of using that style.
Which SQL style are you using?
Related Articles
Community Partners
DevOps Careers