Menu ---
coderinme
  • Programming
    • C
    • C++
    • Java
    • Apex
    • File Handling
    • Python
    • Bash
    • PHP
  • Algorithm
    • Higher Order Thinking Skills Questions
    • Pointer
  • Data Structure
    • Array
    • Linked List
    • Tree
    • Stack
    • Queue
  • Competitive
    • Hackerrank
    • Hackerearth
  • Companies Tech
    • ThoughtWorks
    • NEC Tech
    • TCS
  • Database
    • Data Base and SQL
  • SFDC
    • More
    • Assignment
    • Videos
Menu ---
  • Programming
    • C
    • C++
    • Java
    • Apex
    • File Handling
    • Python
    • Bash
    • PHP
  • Algorithm
    • Higher Order Thinking Skills Questions
    • Pointer
  • Data Structure
    • Array
    • Linked List
    • Tree
    • Stack
    • Queue
  • Competitive
    • Hackerrank
    • Hackerearth
  • Companies Tech
    • ThoughtWorks
    • NEC Tech
    • TCS
  • Database
    • Data Base and SQL
  • SFDC
    • More
    • Assignment
    • Videos

Coder in Me.

Learn coding & Play with it

Home » Database » Data Base and SQL

Category: Data Base and SQL

→

In this Category we will find how to do queries for database and we will know all about database

MySQL basics and Database II

In Data Base and SQL, HackerrankJanuary 28, 2017 hasectic

MySQL basics and Database Continue.. Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. Select city,length(city) from station where length(city) =(select min(length(city)) from station ) order by city limit 1; select city,length(city) from station where length(city) =(select max(length(city)) from station) order by city Query …

Continue Reading

MySQL basics and database

In Data Base and SQL, HackerrankJanuary 28, 2017 hasectic

s MySQL basics and database Revising the Select Query I Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA. select * from City c where c.CountryCode='USA' and c.population>100000 order by ID; Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA. select c.Name from City c where c.CountryCode='USA' and c.Population>120000 order by c.ID; Query all columns (attributes) for every …

Continue Reading
Newer Posts

Site Sidebar

Code Blog

Blog of Coder In Me

Code Division

  • Algorithm
  • Apex
  • Array
  • Assignment
  • Bash
  • C
  • C++
  • Companies Tech
  • Competitive
  • Data Base and SQL
  • Data Structure
  • Database
  • File Handling
  • graph
  • Hackerearth
  • Hackerrank
  • HOTS
  • Java
  • Javascript
  • Linked List
  • More
  • NEC Tech
  • PHP
  • PHP
  • Pointer
  • Programming
  • Project
  • Python
  • Queue
  • SFDC
  • Stack
  • TCS
  • ThoughtWorks
  • Tree
  • Trigger
  • VisualForce Page

Recent Posts

  • Populate Auto Number for Area using Trigger – Coderinme
  • Rest API First Example in Salesforce- CoderinMe
  • Webservice and Callout using REST API for Salesforce – Coderinme
  • SelectList, Select Option & Action Function in Salesforce
  • Batch Class and Scheduler Apex Salesforce – coderinme

Recent Comments

  • chetan upreti on Time Conversion Hackerrank Problem coderinme
  • Shivam on Arrays – DS Hackerrank problem solution
  • Anonymous on A Very Big Sum Hackerrank Problem coderinme
  • hasectic on Arrays – DS Hackerrank problem solution
  • Anonymous on 2D Array – DS Hackerrank problem solution

Site Footer

About Coder In Me

About Coder In Me

Coderinme is the platform where you can learn the basic coding and programming in C , C++, Java, Python,PHP,Shell, MySQL. To evaluate you, Coderinme also provides the Assignment Questions, HOTS(hoigher order thinking skills) Questions.

Monthly Diary

  • January 2019 (3)
  • December 2018 (2)
  • October 2018 (1)
  • September 2018 (1)
  • August 2018 (2)
  • July 2018 (1)
  • May 2018 (11)
  • March 2018 (6)
  • February 2018 (17)
  • January 2018 (8)
  • December 2017 (19)
  • November 2017 (17)
  • October 2017 (11)
  • September 2017 (12)
  • August 2017 (24)
  • July 2017 (11)
  • June 2017 (4)
  • May 2017 (7)
  • March 2017 (6)
  • February 2017 (21)
  • January 2017 (32)
  • December 2016 (4)
  • November 2016 (5)
  • October 2016 (139)

Snapshots

  • About Us
  • Contact Us
  • Videos
  • Higher Order Thinking Skills Questions
  • Terms of Use
  • Privacy Policy
  • Coderinme what and how to use?

Code Blog

Blog of Coder In Me
© Coder in Me 2016-17 coderinme.com