Hi all i am new to sql world and i have some hard time writing sql queries . I be happy if an sql expert tell me what structured method should i use to build sql queries? I want to follow that method to be able to write the correct sql query.I want to learn how to think property to build the query easily once i read english sentence.Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Structured way of building sql query?
- Thread starter QASA25
- Start date
The best advice I can give you is to get a good book and learn everything you can. General SQL books are good but ones geared specifically to your database platform are usually the best. Learn the basics and the nuances and then practice practice practice.
For each problem there can be many solutions and its only with experience that you can develop the ability to pick the best one. Sorry, but there's no quick fix that I know of. I'm not up on the latest good ANSI books; I tend to lean on "The DB2 Cookbook" since I use that platform and it's free to all on the author's website.
Also, check this site out often and ask questions. I've gotten many good tips here.
For each problem there can be many solutions and its only with experience that you can develop the ability to pick the best one. Sorry, but there's no quick fix that I know of. I'm not up on the latest good ANSI books; I tend to lean on "The DB2 Cookbook" since I use that platform and it's free to all on the author's website.
Also, check this site out often and ask questions. I've gotten many good tips here.
- Status
Similar threads
- Locked
- Question