Ideas: How to Correct SQL Queries

There are many ways you can modify a SQL query. Here I am going to cover two types.

Tip–1

  • Take out your production query into test region, and execute and capture results
  • Test your modified query also in test region .
  • Compare your results, then modify your query in production box

Tip–2

  • Online SQL is another option. Where you no need to install any SQL development Software. Then you need to create simple tables and then write your SQL and test it.
  • This way testing is highly useful and you can tweak SQL easily.

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.