This function used to find the sum of fields in various records See the example below Select * from mydoubts_data ————————————- |id | jobid | name | salary | age| ————————————- |1 | 121 | vasanthan| 2000 |32 | |2 | 122 | John | 3000 |28 | |3 | 123 | Kiran | 3400… Read More »
using AVG function will return the average value of particular fields. Example: Select * from mydoubts_data ————————————- |id | jobid | name | salary | age| ————————————- |1 | 121 | vasanthan| 2000 |32 | |2 | 122 | John | 3000 |28 | |3 | 123 | Kiran | 3400 |24 | |4 |… Read More »
This function using to find out the maximum value in a recordset Select * from mydoubts_data ————————————- |id | jobid | name | salary | age| ————————————- |1 | 121 | vasanthan| 2000 |31 | |2 | 122 | John | 3000 |29 | |3 | 123 | Kiran | 3400 |22 | |4 |… Read More »
counting the number of records in a table. Example: Select * from mydoubts_table; ———————————— |firstname | lastname | address | ———————————— |vasanthan | pv | india | |nazar | gt | texas | |raju | raina | sreelanka| |gt | nazar | texas | |Martin | jacob | Dubai | |mydoubts.in | | newyork |… Read More »
union means joining more than tables.It will not create problems if tables having different columns Example: Suppose we have three tables as below Select * from mydoubts_personal; ———————————— |firstname | lastname | address | ———————————— |vasanthan | pv | india | |nazar | gt | texas | ————————————- Select * from mydoubts_buisness ————————————- |last_name |… Read More »
This clause will replace greater/less than conditions Example: Select * from mydoubts_data ————————————- |id | jobid | name | salary | age| ————————————- |1 | 121 | vasanthan| 2000 |31 | |2 | 122 | John | 3000 |29 | |3 | 123 | Kiran | 3400 |22 | |4 | 154 | Raju |… Read More »
In eclipse go to Requirements tab. create DNS Record with Record Type=’a’ and value of settings to that domainname and value of settings to IP
Resource usage updation is doing through Resource script. this script will execute like cron and use the report settings to update the usage.means make the settings variables you need to update.
This error becuase of provisioinging attribute or php module not added in the particular attributes you selected