Software Applications Programming Errors and solutions.

To use  SQL TOP, RANK,  ROW_NUMBER ,DENSE_RANK Functions  you can see below image. Select top 5 records from table. In below query We used SQL TOP, RANK,  ROW_NUMBER ,DENSE_RANK .You can check this with your table.

Tips to Free Up Disk spaces Default Cube Deployment in Ax 2012 Power BI With data connect Data base Shrinking Enable database log on table in Axapta

This is SQL Command chart we read it from starting of any computer diploma which include oracle and SQL. DDL is data definition language,DML is data manipulation language ,DCL is data control language and TCL is Transaction control. TCL Include Set transaction also. DML Include Merge,call ,explain plan,and lock table command too. DDL include comment also.

Below is some details or example what is the use of 'CACHE' ,'NO CACHE' option in sequence 1.Suppose cache is 10 so it will store the next 10 values in advance and that time it some issue happenes with database .we will lose that stored values 2.Values will be fetched from memory by pre-generating them to reduce I/O 3.Cache in sequence specifies that how many values will be stored in memory for faster access,It's default value is 20.