SQL Data Transfer And Aggregation Techniques

COPY ALL DATA TO NEW TABLE


SELECT a.* INTO newTable
FROM oldTable a;

    
    

    
    




  
  
  CAST


CAST(columnName as VARCHAR)
CAST(columnName as INT)

    
    

    
    




  
  
  COUNT SUM OF MULTIPLE TABLE


SELECT SUM(K) AS Total_Row_Count
FROM (
SELECT COUNT(*) FROM TABLE1
UNION
SELECT COUNT(*) FROM TABLE2
) A;