Java Hyd Team

The INNER JOIN keyword selects all rows from both the tables as
long as the condition satisfies. This keyword will create the
result-set by combining all rows from both the tables where the
condition satisfies i.e value of the common field will be the same
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
[9/27, 12:19] ENTREPRENEUR: What is Left Join in SQL?
The Left Join is used to fetch all rows from the left-hand table and
common records between the specified tables.
It returns all the rows from the left-hand side table even though there
are no matches on the right-hand side table.
If it does not find any matching record from the right side table, then it
returns null. This join can also be called a Left Outer Join.
What is the Right JOIN in SQL?
The Right join is used to retrieve all rows from the right-hand table and
only those rows from the other table that fulfill the join condition.
It returns all the rows from the right-hand side table even though there are
no matches in the left-hand side table.
If it finds unmatched records from the left side table, it returns a Null
value. This join is also known as Right Outer Join.
What is self-join and what is the requirement of
self-joining?
A SELF JOIN is used to join a table with self. This join can be performed
using table aliases, which allow us to avoid repeating the same table name
in a single sentence. It will throw an error if we use the same table name
more than once in a single query without using table aliases.
A SELF JOIN is required when we want to combine data with other data in
the same table itself. It is often very useful to convert a hierarchical
structure to a flat structure
[9/27, 12:19] ENTREPRENEUR: The following syntax illustrates the SELF JOIN:
SELECT column_lists
FROM table1 AS T1, table1 AS T2
WHERE join_conditions;
Highest Salary
SELECT name, MAX(salary) as salary
FROM employee
Second highest Salary
Using nested
SELECT name, MAX(salary) AS salary
FROM employee
WHERE salary < (SELECT MAX(salary)
FROM employee);
SELECT salary
FROM employee
ORDER BY salary desc limit 1,1
Third Highest Salary:
SELECT name, MAX(salary) AS salary
FROM employee
WHERE salary < (SELECT MAX(salary)
[9/27, 12:20] ENTREPRENEUR: FROM employee
WHERE salary < (SELECT MAX(salary)
FROM employee) );
● SELECT salary
FROM employee
ORDER BY salary desc limit 2,1
Find Nth highest element
● SELECT salary
FROM employee
ORDER BY salary desc limit n-1,1
JOIN K CODES
i)
SELECT IF(GRADE < 8, NULL, NAME), GRADE, MARKS
FROM STUDENTS JOIN GRADES
WHERE MARKS BETWEEN MIN_MARK AND MAX_MARK
ORDER BY GRADE DESC, NAME
[9/27, 15:38] ENTREPRENEUR: import java.util.*;

class Employee extends Main {

int id;
String name;
Double salary ;
Employee (int id, String name, double salary)
{
this.id=id;
this.name=name;
this.salary=salary;
}

}
public class Main {

public static void main(String[] args)
{
Scanner sc=new Scanner (System.in);
List<Employee>List =new ArrayList<Employee>();

System.out.println("Enter 5 Details : ");

for (int i=1; i<=5; i++) {
System.out.println("Emp-"+ i + " : ");
int id =sc.nextInt();
String name=sc.next();
double salary=sc.nextDouble();

Employee e=new Employee (id,name,salary);
List.add(e);
}
System.out.println("Details are : ");
Iterator <Employee>itr= List.iterator();
while (itr.hasNext()) {
Employee e=itr.next();
System.out.println(e.id+ " : " +e.name + " : " + e.salary);

}
}

}
[9/29, 16:55] ENTREPRENEUR: //Find sum of n numbers through threading ...

import java.util.*;
public class Defaults {
static int n ;
public static void main(String[] args) {
Scanner x = new Scanner(System.in);
System.out.print("Sum of N numbers ");

37 views15:17