Thursday, February 2, 2017

Basic of SQL 6





- No comments:

Basics of SQL 5




    

- No comments:

Basics of SQL 4






       

- No comments:

Basics SQL 3


        



                        
                              

- No comments:

Wednesday, February 1, 2017

Basics of SQL 2


- No comments:
Subscribe to: Posts (Atom)

Read data from csv in R Programming

Read a data set from csv file.. x <- read.csv(file.choose(),header=TRUE) here x is the R data set vaiable.

  • NTILE In Oracle
    Hi friends today we will discuss about NTILE in Oracle: Syntax:    SELECT NTILE(NUMBER) OVER (ORDER BY <COLUMN>) FROM TABLE; Ex...
  • TRUNC on DATE in Oracle to SQL SERVER
    Hi all .., Here is the date formats, conversions to SQL Server.. Oracle SQL Server SELECT TRUNC(SYSDATE) FROM dual;  CONVER...
  • CHILD_RECORD_FOUND Equivalent in SQL Server
    HI All..,, for CHILD_RECORD_FOUND in Oracle , in SQL Server is Error_number = 547 begin try --------- ---------- end try  begin ca...