Facebook

SQL XML Queries

SQL XML: You can generate XML from SQL queries without even doing single line of code in your programming language. Below is the script used...

Sub Queries-

Three basic rules only. Where you can place sub query?3 places where you can place your sub query:SELECT —– FROMFROM   —– WHEREWHERE  —–> SELECT...
What View do ?• First,  It help you break down complex queries.• Secong, Query reusability.• Third, Security.(not fully recommendable) What is View ?View is just...

SQL for Beginners

SQL (Structured Query Language) It is high level language which provide you capability to query data from any structured data source (Tables).  High level language...