Answer: oh hello human :) also PLEASE DONT KILL ME I’m answering this because the question was already answered already on another post
Answer:
UPDATE acctmanager WHERE amid = 'J500';
Explanation:
The statement written above is not valid SQL statement because there is no SET after UPDATE. Update is always used with SET.If you are updating something then you need to specify the value with which that value should be replaced.
UPDATE acctmanager SET amname = UPPER(amname);
This statement does not contains WHERE clause but it will run all the values of amname column will get updated in the table acctmanager.
Answer:
import java.util.*;
public class MyClass {
public static void main(String args[]) {
Scanner input = new Scanner(System.in);
System.out.print("Input a word: ");
String userinput = input.nextLine();
for(int i =0;i<userinput.length();i+=2) {
System.out.print(userinput.charAt(i));
}
}
}
Explanation:
This line prompts user for input
System.out.print("Input a word: ");
This declares a string variable named userinput and also gets input from the user
String userinput = input.nextLine();
The following iterates through every other character of userinput from the first using iteration variable i and i is incremented by 2
for(int i =0;i<userinput.length();i+=2) {
This prints characters at i-th position
System.out.print(userinput.charAt(i));
Answer:
import java.util.Arrays;
import java.util.Scanner;
public class num4 {
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
System.out.println("How many numbers? ");
int n = in.nextInt();
int []intArray = new int[n];
//Entering the values
for(int i=0; i<intArray.length;i++){
System.out.println("Enter the numbers");
intArray[i]=in.nextInt();
}
System.out.println(Arrays.toString(intArray));
int min =intArray[0];
for(int i =0; i<intArray.length; i++){
if(min>intArray[i]){
min = intArray[i];
}
}
System.out.println("The Minimum of the numbers is "+min);
}
}
Explanation:
- Using Java programming language
- Prompt the user for the number of values
- Using Scanner class receive and store in a variable
- Create an array of size n
- Using an for loop continuously ask the user to enter the integers
- Print the array of integers
- Using another for loop with an if statement, find the smallest element in the array of numbers
- Output the the smallest number