ShowCode

 @@@@ Submissions Leaderboard Discussions Query a list of  CITY  names from  STATION  for cities that have an even  ID  number. Print the results in any order, but exclude duplicates from the answer. ==  SELECT DISTINCT CITY FROM STATION       WHERE MOD(ID,2)=0; Find the difference between the total number of  CITY  entries in the table and the number of distinct  CITY  entries in the table. = SELECT COUNT(*) - COUNT(DISTINCT CITY) AS DIFFERENCE FROM STATION;

 Three types of JDBC Statement  1. Statement  Code: Statement st  = conn.createStatement(); 2. PreparedStatement  Code : PreparedStatement pst = con.prepareStatement("SELECT * FROM my_table WHERE id = ?"); pst.setInt(1, 345); 3. CallableStatement Code: CallableStatement cst = conn.prepareCall(" {call update_customer(?, ?) } "); cst.setString(1, "hohn"); cst.setString(2, "Doe"); Scrollable ResultSet  Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet rs = st.executeQuery("Select * From my_table); ;

 Data Types of Python : There are several types of Built-in data types in Python. 1. Numeric Type :  Numeric types include integers, floats, and complex numbers. Integers are whole numbers, floats are decimal numbers, and complex numbers are numbers with a real and imaginary part. 2. Boolean Type :  The Boolean type represents truth values, which can be either True or False. 3. Sequence Types  Sequence types include strings, lists, and tuples. Strings are sequences of characters, while lists and tuples are sequences of values of any data type. 4. Mapping Type  The mapping type is represented by dictionaries, which are collections of key-value pairs. 5. Set Types Set types include sets and frozensets. Sets are unordered collections of unique values, while frozensets are immutable sets. Small Code related to Data Types is below : # Numeric Types my_int = 42 my_float = 3.14 my_complex = 2 + 3j # Boolean Type my_bool = True # Sequence Types my_string = "Hello, Wo...

Python else if condition  n = int ( input () . strip ()) check = { True : "Not Weird" , False : "Weird" } print ( check [ n % 2 == 0 and ( n in range ( 2 , 6 ) or n > 20 ) ])

 Node js Basic CRUD Operation...... /* create a folder and file first.... */ /* now first we create folder with file name data.txt ...*/ const fs = require('fs'); fs.mkdirSync("anish"); /* create a file with filename data.txt ..*/ fs.writeFileSync("data.txt", "Welcome to my file "); /* you are able to append new things in this file.... */ fs.append("data.txt", "We are file creator"); /*  you also rename this file ...*/ fs.renameSync("data.txt", "hello.txt"); /* now finally you delete that file  */ fs.unlinkSync("hello.txt");

  Super Keyword in java Super Keyword is used to prefer parent class during inheritance.  Super is used in two scenario:::::::: 1. Use with variables. class Animal { public int weigth = 130; } class Height extends Animal { public int weight = 200; public void display(){ System.out.println("Weight = "+super.weight); } } class Driver { public static void main(String args[]) {   Height obj = new Height();    obj.display(); } }