Skip to content

Data944/SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Basic and Intermediate SQL Functions

  • I downloaded Microsoft SQL and ran basic and intermediate queries in the application
  • Basic query functions include creating table, insert into, select from and where statement
  • Select statement includes top, distinct, count, as, max, min, avg functions as well
  • Where statement includes <> (excludes), and, or, like, null, not null, in
  • Intermediate query functions include joins, unions, case statements, having clause, updating/deleting data, aliasing, partition by, views, getdate(), primary Key and foreign key
  • Joins includes Inner joins, Full/Left/Right Outer join functions
  • Unions include Union, Union All functions
  • Getdate() function includes dateadd and datediff functions within queries along with a case statement

About

Initial work with SQL

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published