SQl.....(Structured query language)

 

 SQL Series........

CITY.jpg




Query from Table of GEEKS For GEEKS .......

SELECT * 
FROM CITY
WHERE
POPULATION > 100000 AND
COUNTRYCODE = 'USA';



1. Create Table in SQL:
CREATE TABLE Table_name (
   column_name data_type;
   column_name data_type; 
);

Data_types in SQL ::::
-- integer
--Varchar(limit)

2. Select in SQL
-- SELECT (data- *, column_name) FROM (table_name) 
-- use WHERE for Condition ....... Like : 
SELECT * FROM Table WHERE (condition)....



Comments

Post a Comment

Popular posts from this blog

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 ) ])
Read more

About RAM

Image
 RAM. About RAM  RAM stand's for Random Access Memory. RAM is type of Memory device which holds programs or instructions which is going to be executed. So we  say that RAM is a primary memory which stores currently running programs . Some features of RAM are as Follows:: --RAM is a volatile memory  --It is expensive memory device.  --We read and write data instructions in RAM. --High speed memory Types of RAM are ::: 1. Static RAM (SRAM)  2. Dynamic RAM (DRAM) Pic of RAM given below.... Pic: RAM  from:google.com
Read more

Class and object in c++

 Program in Class and Object: #include   < cmath > #include   < cstdio > #include   < vector > #include   < iostream > #include   < algorithm > #include   < cassert > using   namespace   std ; // Write your Student class here class   Student   {      private :      int   score [ 5 ];           public :      void   input ()      {        for ( int   i = 0 ; i < 5 ;++ i )        {            cin >> score [ i ];        }         }      int   calculateTotalScore ()      {          int ...
Read more