SQL Important programing

we have two table table jobs and journey details and jobid are common in both the table means jobs id are multiples time in the journey details jobid=1,jobid=1,jobid=1, and we are try to fetching data on the basis of departmentid on the both table so that we will get the data or multiples job present in the journey details table .Please check the given picture so that you will easily understand the whole scenario :)






!> create two table


Insert data into the tables

Comments

Post a Comment

Popular posts from this blog

Prime Number Program in C#

Prime number is a number that is greater than 1 and divided by 1 or itself. In other words, prime numbers can't be divided by other numbers than itself or 1. For example 2, 3, 5, 7, 11, 13, 17, 19, 23.... are the prime numbers. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int number, i, m = 0, flag = 0;             Console.WriteLine("PLEASE ENTER THE NUMBER TO CHECK PRIME NUMBER");             number = int.Parse(Console.ReadLine());             m = number / 2;             for(i=2;i<=m;i++)             {           ...
Read more

Fibonacci Series in C#

In the case of Fibonacci series, the next number is the sum of the previous two numbers for example 0, 1, 1, 2, 3, 5, 8, 13, 21 etc. The first two numbers of Fibonacci series are 0 and 1. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 {     class Program     {         static void Main(string[] args)         {             int val1 = 0, val2 = 1, val3, i, number;             Console.WriteLine("Please Enter any number");             number = int.Parse(Console.ReadLine());             Console.WriteLine(val1 + " " + val2);             for (i=2;i<=number;i++)             {                 val3 =...
Read more

Temporary tables

Image
Temporary tables, are very similar to the permanent tables. Permanent tables get created in the database you specify, and remain in the database  permanently, until you delete (drop) them. On the other hand, temporary tables get created in the TempDB and are automatically deleted, when they are  no longer used. Types of Temporary tables  - Local Temporary tables    -Global Temporary tables.   A local temporary table is automatically dropped , when the connection that has created the it, is closed. If the user wants to explicitly drop the  temporary table, he can do so using DROP TABLE  #PersonDetails If the temporary table, is created inside the stored procedure , it get's dropped automatically upon the completion of stored procedure execution. The  stored procedure below, creates  #PersonDetails  temporary table, populates it and then finally returns the data and destroys the temporary table  immediately after...
Read more