01.SQL JOIN

-

SQL JOIN




01.Left Join

All the data in left table + matching data from other table.

All the data in the left table will be displayed irrespectively if it has matching entry or it does not have matching entry on the other table.

SELECT * FROM school sc LEFT JOIN student st ON sc.school_Id = st. school_Id;





02.Right Join

All the data in right table + matching  data from other table.

All the data in the right table will be displayed irrespectively if it has matching entry or it does not have matching entry on the other table.

 

SELECT * FROM school sc RIGHT JOIN student st ON sc.school_Id = st. school_Id;

 




03.Inner Join

Common data from both table.

Where data is matching in these two table on those record will be displayed.

SELECT * FROM school sc INNER JOIN student st ON sc.school_Id = st. school_Id;

 




04.Full Outer Join

All the data from both tables.

SELECT * FROM school sc FULL OUTER JOIN  student st ON sc.school_Id = st. school_Id;





Comments

Post a Comment

Popular posts from this blog

02. Spring – Creating spring project clone it with GIT step by step.

-
Image
  Creating spring project clone it with GIT step by step. 01. Create an empty GIT repository and select a repository name. 02.   Check to add README.md and technology to add it inside the gitignire file0- it will include all the generated class when we complete the application. 03.      Copy the github repository URL. 04 . Open eclipse and go to,             Window – Show View – Other - Type git on the folder and select git repositories. 05.   Now clone this repository at your desired location in which we are going to keep the project specific file . a)         a)  Step One.             b)  Step  Two .          c)    Step Three. Both projects are generated as bellows           d) Step Four  Open the gitingnore file and ignore the target folder of the project. All the class files which are generate with compile the code are store in target folder. Class file can be generated. Because of that we don’t commit that folder to git.           e) Step Five Open window – preference – filter fo
Read more

02.What is MicroService?

-
Image
What is MicroService? MicroService යනු තනි application එකක් (Monolithic Application එකක්), එකිනෙක communicate කරගන පුළුවන් වෙන වෙනම deploy වන කුඩා කුඩා independent services වලට කැඩීමයි. Simply it is new way to develop application rather than traditional monolithic application. Companies which are using microservice.   Features of MicroService Architecture Small focused – main aim of microservice is simplicity.it can be rewrite in maintained without extra effort. Loosely coupled – development as well as deployment is quick. Language Neutral – few services can be Java, few is c# few can be python.it can be use depend on the service. Bounded Context – each microservice does not need to understand the implementation of the other microservice.
Read more

06.Mongo DB - Query part 2 (Aggregation)

-
Image
    Project can be download from         https://github.com/LahiruPriyankara/SpringBootAppTwo-MongoDB MongoDB Aggregation This groups values from multiple documents together and can perform variety of operations on that grouped data.it is going to return single result after the aggregation. Stages In Aggregation: Those operation are used in group of documents ( Used inside aggregation stages).  Unary Operation -  Unary operator perform operation for each documents. Type - Given the type of the filed. In the SQL we query select count and in the bracket Astrix this count for aggregation. It return the number of rows. This is same in mongoDB. db . employee . aggregate ([ { $group : { _id : "$gender" , genderCount : { $sum : 1 } } } ]) // $sum: 1 :1 - true db . employee . aggregate ([ { $group : { _id : "$gender" , maxAge : { $max : "$age" } } } ]) Bellow example is from  https://docs.mongodb.com/manual/aggregation/ Single Purpose Aggregation
Read more