User @Sai_kiran_rachakonda

left join

June 25, 2022 ·

SQL

CREATE TABLE palette_a (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
CREATE TABLE palette_b (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
INSERT INTO palette_a (id, color)
VALUES (1, 'Red');

Inner join

June 25, 2022 ·

SQL

CREATE TABLE palette_a (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
CREATE TABLE palette_b (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
INSERT INTO palette_a (id, color)
VALUES (1, 'Red');

example (SQL)

June 25, 2022 ·

SQL

CREATE TABLE palette_a (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
CREATE TABLE palette_b (
    id INT PRIMARY KEY,
    color VARCHAR2 (100) NOT NULL
);
INSERT INTO palette_a (id, color)
VALUES (1, 'Red');

example (SQL)

June 25, 2022 ·

SQL

-- create a table
CREATE TABLE students (
  fname char,
  lname char,
  num int
);
-- insert some values
INSERT INTO students VALUES ('sai', 'Ryan', 123);
INSERT INTO students VALUES ('pavan', 'Joanna', 456);
insert into students values('venkat', 'sujatha', 789);

example (SQL)

June 18, 2022 ·

SQL

-- create a table
CREATE TABLE students (
  fname char,
  lname char,
  num int
);
-- insert some values
INSERT INTO students VALUES ('sai', 'Ryan', 123);
INSERT INTO students VALUES ('pavan', 'Joanna', 456);
insert into students values('venkat', 'sujatha', 789);

example (SQL)

June 18, 2022 ·

SQL

-- create a table
CREATE TABLE students (
  fname char,
  lname char,
  num int
);
-- insert some values
INSERT INTO students VALUES ('sai', 'Ryan', 123);
INSERT INTO students VALUES ('pavan', 'Joanna', 456);
insert into students values('venkat', 'sujatha', 789);

example (SQL)

June 18, 2022 ·

SQL

-- create a table
CREATE TABLE students (
  fname char,
  lname char,
  num int
);
-- insert some values
INSERT INTO students VALUES ('sai', 'Ryan', 123);
INSERT INTO students VALUES ('pavan', 'Joanna', 456);
insert into students values('venkat', 'sujatha', 789);

example (SQL)

June 17, 2022 ·

SQL

-- create a table
CREATE TABLE students (
  fname char,
  lname char,
  num int
);
-- insert some values
INSERT INTO students VALUES ('sai', 'Ryan', 123);
INSERT INTO students VALUES ('pavan', 'Joanna', 456);
insert into students values('venkat', 'sujatha', 789);

example

June 17, 2022 ·

Python

import numpy as np

example

June 16, 2022 ·

Python

class Person:
    def __init__ (self, name = 'Kiran', age = 23, city = 'california'):
        self.name = name
        self.age = age
        self.city = city
        
    def olive(self):
        return f'{self.name} is {self.age} years old. He lives in {self.city}.'
        
p = Person()

Class and objects - 3

June 16, 2022 ·

Python

class Person:
    def __init__ (self, name, age, city, country):
        self.name = name
        self.age = age
        self.city = city
        self.country = country
        self.skills = []
        
    def person_info(self):
        return f'{self.name} is {self.age} years old. He lives in {self.city}.'

Class and object - 3

June 16, 2022 ·

Python

class Person:
    def __init__ (self, name, age, city, country):
        self.name = name
        self.age = age
        self.city = city
        self.country = country
        self.skills = []
        
    def person_info(self):
        return f'{self.name} is {self.age} years old. He lives in {self.city}.'

example

June 16, 2022 ·

Python

class Person:
    def __init__ (self, name = 'Kiran', age = 23, city = 'california'):
        self.name = name
        self.age = age
        self.city = city
        
    def olive(self):
        return f'{self.name} is {self.age} years old. He lives in {self.city}.'
        
p = Person()

class and objects - 2

June 16, 2022 ·

Python

class Person:
    def __init__ (self, name = 'Kiran', age = 23, city = 'california'):
        self.name = name
        self.age = age
        self.city = city
        
    def olive(self):
        return f'{self.name} is {self.age} years old. He lives in {self.city}.'
        
p = Person()

class and objects

June 16, 2022 ·

Python

class Person:
    def __init__ (self, name, age, sal, city):
        self.name = name
        self.age = age
        self.sal = sal
        self.city = city
        
p = Person('saikiran', 23,250000, 'california')
print(p.name)
print(p.age)

example

June 16, 2022 ·

Python

import re

example

June 14, 2022 ·

Python

def binsearch(x):
    for i in range(len(x)):
        if i not in x:
            print(i)
            break




binsearch([1,2,4,5,6,8,9,10,11,12,13])

example

June 14, 2022 ·

Python

def binsearch(x):
    for i in range(len(x)):
        if i not in x:
            print(i)
            break


binsearch([1,2,4,5,6,8,9,10,11,12,13])

printing first non-negative missing element

June 14, 2022 ·

Python

def binsearch(x):
    for i in range(len(x)):
        if i not in x:
            print(i)
            break


binsearch([1,2,4,5,6,8,9,10,11,12,13])

recursion (palindrome)

June 14, 2022 ·

Python

def palindrome(s):
    if len(s) < 1:
        return True
    else:
        if s[0] == s[-1]:
            return palindrome(s[1:-1])
        else:
            return False
                
print(palindrome('malayalam'))