The output of the above query was :
Hence, it can be concluded that sub query takes more time to execute than the normal SQL query.
| import java.lang.String; | |
| // import java.util.Arrays; | |
| public class MString { | |
| private char[] theChars; | |
| private int n; | |
| private void expand(int mustHaveCapacity) { | |
| char[] temp = new char[2 * mustHaveCapacity]; | |
| System.out.println("Temp size : " + temp.length); |
| prog START 1000 | |
| LDA FIVE | |
| ADD ONE | |
| STA ALPHA | |
| ALPHA RESW 1 | |
| FIVE WORD 5 | |
| ONE WORD 1 | |
| END |
| class NestedSwitch { | |
| public static void main(String[] args) { | |
| // Necessary Condition | |
| int num1 = 100; | |
| // Supplement Condition | |
| int num2 = 221; | |
| // Necessary Switch |
| .model small | |
| .stack 100h | |
| .data | |
| first db 10,13, "Enter first character : $" | |
| second db 10,13, "Enter second character : $" | |
| output db 10,13, "The output is : $" | |
| .code | |
| main proc | |
| num = int(input()) | |
| result = {} | |
| for i in range(num): | |
| n, r, c, sr, sc = list(map(int, input().rstrip().split())) | |
| instructions = list(input().rstrip()) | |
| visited = list() | |
| visited.append((sr, sc)) |
| import java.sql.Connection; | |
| import java.sql.DriverManager; | |
| import java.sql.SQLException; | |
| import java.sql.Statement; | |
| public class UpdateManagerSalary { | |
| private static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; | |
| private static final String JDB_URL = "jdbc:mysql://localhost:3306/testdb"; |
| /* This program checks whether your device is connected to Internet or not. */ | |
| import java.net.InetSocketAddress; | |
| import java.net.Socket; | |
| /** | |
| * @author arjun | |
| */ | |
| public class IsInternetAvailable { | |
| public static void main(String[] args) { |
It's a common challenge mostly seen in interviews in bigger tech companies for hiring.
In this solution done by me, it's referenced according to the video.