暗記メーカー

暗記メーカー

​
ログイン

DML COMMANDS

DML COMMANDS
14問 • 2年前
  • Guillermo, Rizchel Anne B.
    • 通報

    問題一覧

  • 1

    DEFAULT SQL QUERY EDITOR:

    SELECT TOP (200) <column list> FROM [table_name]

  • 2

    CODE TO INSERT DATA: (3 columns and values)

    INSERT INTO [table_name] ( [column1], [column2], [column3] ) VALUES ( ‘value1’, ‘value2’, ‘value3’ )

  • 3

    4.2 CHANGING VALUES:

    USE [database_name] UPDATE [table_name] SET [column name] = ‘new value’ WHERE [column name] = ‘original value’;

  • 4

    4.2 CHANGE lastname ‘vergra’ to ‘vergara’:

    USE [database_name] UPDATE [table_name] SET lastname = ‘vergara’ WHERE lastname = ‘vergra’;

  • 5

    4.3 DELETE DATA

    USE [database_name] DELETE FROM [table_name] WHERE [column name] = ‘value’

  • 6

    4.3 DELETE ‘1008’ Column (it deletes not just the specific value you entered)

    USE [database_name] DELETE FROM [table_name] WHERE studentnumber = ‘1008’

  • 7

    4.4 - SQL Query TO VIEW THE CONTENT OF THE TABLE

    USE [database_name] SELECT * FROM [table_name]

  • 8

    4.5 VIEW TABLE - TOP 1000

    SELECT <column list> FROM [table_name]

  • 9

    4.5 IF YOU WANT TO DISPLAY SPECIFIC COLUMNS lastname, firstname, and middlename in ONE COLUMN

    SELECT studentnumber UPPER(lastname) + ‘, ‘ + UPPER(firstname) + SPACE(1) + UPPER(middlename) AS [new_column_name] FROM [table_name] SELECT column1 UPPER(column2) + ‘, ‘+ SPACE(1) + UPPER(column3) AS [new_column_name] FROM [table_name]

  • 10

    4.5 IN ASCENDING ORDER

    SELECT * FROM [table_name] ORDER BY lastname

  • 11

    4.5 IN DESCENDING ORDER

    SELECT * FROM [table_name] ORDER BY lastname DESC

  • 12

    4.5 ARRANGED BASED ON LASTNAME AND FIRSTNAME

    SELECT * FROM [table_name] ORDER BY lastname, firstname

  • 13

    YOU WANT TO SEE HOW MANY STUDENTS RESIDE IN CARMONA, CAVITE (address1 column name) (specific entry as value)

    SELECT * FROM [table_name] WHERE (address1 = ‘Carmona, Cavite’)

  • 14

    4.5 HOW MANY STUDENTS HAVE SAME ADDRESS AS HIS GUARDIAN (column as conditional value)

    SELECT * FROM [table_name] WHERE (address1 = [guardian address])

    • KEY TERMS

    KEY TERMS

    Guillermo, Rizchel Anne B. · 17問 · 2年前

    KEY TERMS

    KEY TERMS

    17問 • 2年前
    Guillermo, Rizchel Anne B.

    TLE KEY TERMS

    TLE KEY TERMS

    Guillermo, Rizchel Anne B. · 18問 · 2年前

    TLE KEY TERMS

    TLE KEY TERMS

    18問 • 2年前
    Guillermo, Rizchel Anne B.

    TLE CLASSIFICATION OF PROGRAMMING LANGUAGE, PROGRAM DEVELOPMENT PROCESS

    TLE CLASSIFICATION OF PROGRAMMING LANGUAGE, PROGRAM DEVELOPMENT PROCESS

    Guillermo, Rizchel Anne B. · 59問 · 2年前

    TLE CLASSIFICATION OF PROGRAMMING LANGUAGE, PROGRAM DEVELOPMENT PROCESS

    TLE CLASSIFICATION OF PROGRAMMING LANGUAGE, PROGRAM DEVELOPMENT PROCESS

    59問 • 2年前
    Guillermo, Rizchel Anne B.

    ALGORITHM/FLOW CHART

    ALGORITHM/FLOW CHART

    Guillermo, Rizchel Anne B. · 33問 · 2年前

    ALGORITHM/FLOW CHART

    ALGORITHM/FLOW CHART

    33問 • 2年前
    Guillermo, Rizchel Anne B.

    AP ARTICLES. UDHR Universal Declaration Of HumanRights

    AP ARTICLES. UDHR Universal Declaration Of HumanRights

    Guillermo, Rizchel Anne B. · 30問 · 2年前

    AP ARTICLES. UDHR Universal Declaration Of HumanRights

    AP ARTICLES. UDHR Universal Declaration Of HumanRights

    30問 • 2年前
    Guillermo, Rizchel Anne B.

    1-10 ARTICLES (UDHR)

    1-10 ARTICLES (UDHR)

    Guillermo, Rizchel Anne B. · 10問 · 2年前

    1-10 ARTICLES (UDHR)

    1-10 ARTICLES (UDHR)

    10問 • 2年前
    Guillermo, Rizchel Anne B.

    11-20 ARTICLES (UDHR)

    11-20 ARTICLES (UDHR)

    Guillermo, Rizchel Anne B. · 10問 · 2年前

    11-20 ARTICLES (UDHR)

    11-20 ARTICLES (UDHR)

    10問 • 2年前
    Guillermo, Rizchel Anne B.

    21-30 ARTICLES (UDHR)

    21-30 ARTICLES (UDHR)

    Guillermo, Rizchel Anne B. · 10問 · 2年前

    21-30 ARTICLES (UDHR)

    21-30 ARTICLES (UDHR)

    10問 • 2年前
    Guillermo, Rizchel Anne B.

    LESSON 8

    LESSON 8

    Guillermo, Rizchel Anne B. · 23問 · 2年前

    LESSON 8

    LESSON 8

    23問 • 2年前
    Guillermo, Rizchel Anne B.

    DDL

    DDL

    Guillermo, Rizchel Anne B. · 22問 · 2年前

    DDL

    DDL

    22問 • 2年前
    Guillermo, Rizchel Anne B.

    SQL

    SQL

    Guillermo, Rizchel Anne B. · 38問 · 2年前

    SQL

    SQL

    38問 • 2年前
    Guillermo, Rizchel Anne B.

    BILL RIGHTS 1-11

    BILL RIGHTS 1-11

    Guillermo, Rizchel Anne B. · 11問 · 2年前

    BILL RIGHTS 1-11

    BILL RIGHTS 1-11

    11問 • 2年前
    Guillermo, Rizchel Anne B.

    CREATING, ALTERING AND DELETING DATABASES

    CREATING, ALTERING AND DELETING DATABASES

    Guillermo, Rizchel Anne B. · 29問 · 2年前

    CREATING, ALTERING AND DELETING DATABASES

    CREATING, ALTERING AND DELETING DATABASES

    29問 • 2年前
    Guillermo, Rizchel Anne B.

    DML

    DML

    Guillermo, Rizchel Anne B. · 23問 · 2年前

    DML

    DML

    23問 • 2年前
    Guillermo, Rizchel Anne B.

    BILL OF RIGHTS 12-22

    BILL OF RIGHTS 12-22

    Guillermo, Rizchel Anne B. · 12問 · 2年前

    BILL OF RIGHTS 12-22

    BILL OF RIGHTS 12-22

    12問 • 2年前
    Guillermo, Rizchel Anne B.

    BOWC

    BOWC

    Guillermo, Rizchel Anne B. · 14問 · 2年前

    BOWC

    BOWC

    14問 • 2年前
    Guillermo, Rizchel Anne B.

    Sektor ng Paglilingkod

    Sektor ng Paglilingkod

    Guillermo, Rizchel Anne B. · 10問 · 2年前

    Sektor ng Paglilingkod

    Sektor ng Paglilingkod

    10問 • 2年前
    Guillermo, Rizchel Anne B.

    MERCHANT OF VENICE

    MERCHANT OF VENICE

    Guillermo, Rizchel Anne B. · 17問 · 2年前

    MERCHANT OF VENICE

    MERCHANT OF VENICE

    17問 • 2年前
    Guillermo, Rizchel Anne B.

    Impormal na sektor

    Impormal na sektor

    Guillermo, Rizchel Anne B. · 9問 · 2年前

    Impormal na sektor

    Impormal na sektor

    9問 • 2年前
    Guillermo, Rizchel Anne B.

    MUSIC

    MUSIC

    Guillermo, Rizchel Anne B. · 34問 · 2年前

    MUSIC

    MUSIC

    34問 • 2年前
    Guillermo, Rizchel Anne B.

    ARTS

    ARTS

    Guillermo, Rizchel Anne B. · 29問 · 2年前

    ARTS

    ARTS

    29問 • 2年前
    Guillermo, Rizchel Anne B.

    HEALTH

    HEALTH

    Guillermo, Rizchel Anne B. · 26問 · 2年前

    HEALTH

    HEALTH

    26問 • 2年前
    Guillermo, Rizchel Anne B.

    IMPORMAL NA SEKTOR

    IMPORMAL NA SEKTOR

    Guillermo, Rizchel Anne B. · 40問 · 2年前

    IMPORMAL NA SEKTOR

    IMPORMAL NA SEKTOR

    40問 • 2年前
    Guillermo, Rizchel Anne B.

    THERMODYNAMICS

    THERMODYNAMICS

    Guillermo, Rizchel Anne B. · 40問 · 2年前

    THERMODYNAMICS

    THERMODYNAMICS

    40問 • 2年前
    Guillermo, Rizchel Anne B.

    DRAMATIC ELEMENTS

    DRAMATIC ELEMENTS

    Guillermo, Rizchel Anne B. · 29問 · 2年前

    DRAMATIC ELEMENTS

    DRAMATIC ELEMENTS

    29問 • 2年前
    Guillermo, Rizchel Anne B.

    20

    20

    Guillermo, Rizchel Anne B. · 10問 · 2年前

    20

    20

    10問 • 2年前
    Guillermo, Rizchel Anne B.

    Work Power Energy

    Work Power Energy

    Guillermo, Rizchel Anne B. · 29問 · 2年前

    Work Power Energy

    Work Power Energy

    29問 • 2年前
    Guillermo, Rizchel Anne B.

    A6 - Kalakalang Panlabas

    A6 - Kalakalang Panlabas

    Guillermo, Rizchel Anne B. · 41問 · 2年前

    A6 - Kalakalang Panlabas

    A6 - Kalakalang Panlabas

    41問 • 2年前
    Guillermo, Rizchel Anne B.

    A6 - APEC and Presidents

    A6 - APEC and Presidents

    Guillermo, Rizchel Anne B. · 22問 · 2年前

    A6 - APEC and Presidents

    A6 - APEC and Presidents

    22問 • 2年前
    Guillermo, Rizchel Anne B.

    4D - MUSIC

    4D - MUSIC

    Guillermo, Rizchel Anne B. · 9問 · 2年前

    4D - MUSIC

    4D - MUSIC

    9問 • 2年前
    Guillermo, Rizchel Anne B.

    4D - ARTS

    4D - ARTS

    Guillermo, Rizchel Anne B. · 46問 · 2年前

    4D - ARTS

    4D - ARTS

    46問 • 2年前
    Guillermo, Rizchel Anne B.

    4D - PE

    4D - PE

    Guillermo, Rizchel Anne B. · 8問 · 2年前

    4D - PE

    4D - PE

    8問 • 2年前
    Guillermo, Rizchel Anne B.

    4D - HEALTH

    4D - HEALTH

    Guillermo, Rizchel Anne B. · 15問 · 2年前

    4D - HEALTH

    4D - HEALTH

    15問 • 2年前
    Guillermo, Rizchel Anne B.

    Electricity and Magnetism

    Electricity and Magnetism

    Guillermo, Rizchel Anne B. · 51問 · 2年前

    Electricity and Magnetism

    Electricity and Magnetism

    51問 • 2年前
    Guillermo, Rizchel Anne B.

    William

    William

    Guillermo, Rizchel Anne B. · 19問 · 2年前

    William

    William

    19問 • 2年前
    Guillermo, Rizchel Anne B.

    Magnetism

    Magnetism

    Guillermo, Rizchel Anne B. · 29問 · 2年前

    Magnetism

    Magnetism

    29問 • 2年前
    Guillermo, Rizchel Anne B.

    21

    21

    Guillermo, Rizchel Anne B. · 7問 · 2年前

    21

    21

    7問 • 2年前
    Guillermo, Rizchel Anne B.

    MP1

    MP1

    Guillermo, Rizchel Anne B. · 55問 · 2年前

    MP1

    MP1

    55問 • 2年前
    Guillermo, Rizchel Anne B.

    1.1 Kontemporaryong Isyu

    1.1 Kontemporaryong Isyu

    Guillermo, Rizchel Anne B. · 32問 · 2年前

    1.1 Kontemporaryong Isyu

    1.1 Kontemporaryong Isyu

    32問 • 2年前
    Guillermo, Rizchel Anne B.

    AP1

    AP1

    Guillermo, Rizchel Anne B. · 65問 · 2年前

    AP1

    AP1

    65問 • 2年前
    Guillermo, Rizchel Anne B.

    PP1 - Health Related

    PP1 - Health Related

    Guillermo, Rizchel Anne B. · 14問 · 2年前

    PP1 - Health Related

    PP1 - Health Related

    14問 • 2年前
    Guillermo, Rizchel Anne B.

    PP1- Skill Related

    PP1- Skill Related

    Guillermo, Rizchel Anne B. · 18問 · 2年前

    PP1- Skill Related

    PP1- Skill Related

    18問 • 2年前
    Guillermo, Rizchel Anne B.

    AGENCIES

    AGENCIES

    Guillermo, Rizchel Anne B. · 14問 · 2年前

    AGENCIES

    AGENCIES

    14問 • 2年前
    Guillermo, Rizchel Anne B.

    MP1

    MP1

    Guillermo, Rizchel Anne B. · 19問 · 2年前

    MP1

    MP1

    19問 • 2年前
    Guillermo, Rizchel Anne B.

    APD1

    APD1

    Guillermo, Rizchel Anne B. · 42問 · 2年前

    APD1

    APD1

    42問 • 2年前
    Guillermo, Rizchel Anne B.

    ARGUMENTATIVE ESSAY

    ARGUMENTATIVE ESSAY

    Guillermo, Rizchel Anne B. · 28問 · 2年前

    ARGUMENTATIVE ESSAY

    ARGUMENTATIVE ESSAY

    28問 • 2年前
    Guillermo, Rizchel Anne B.

    LOGICAL FALLACIES

    LOGICAL FALLACIES

    Guillermo, Rizchel Anne B. · 42問 · 2年前

    LOGICAL FALLACIES

    LOGICAL FALLACIES

    42問 • 2年前
    Guillermo, Rizchel Anne B.

    CASE PRONOUNS

    CASE PRONOUNS

    Guillermo, Rizchel Anne B. · 19問 · 2年前

    CASE PRONOUNS

    CASE PRONOUNS

    19問 • 2年前
    Guillermo, Rizchel Anne B.

    AP

    AP

    Guillermo, Rizchel Anne B. · 55問 · 2年前

    AP

    AP

    55問 • 2年前
    Guillermo, Rizchel Anne B.

    PP

    PP

    Guillermo, Rizchel Anne B. · 41問 · 2年前

    PP

    PP

    41問 • 2年前
    Guillermo, Rizchel Anne B.

    FALL OF TROY

    FALL OF TROY

    Guillermo, Rizchel Anne B. · 9問 · 2年前

    FALL OF TROY

    FALL OF TROY

    9問 • 2年前
    Guillermo, Rizchel Anne B.

    HP

    HP

    Guillermo, Rizchel Anne B. · 19問 · 2年前

    HP

    HP

    19問 • 2年前
    Guillermo, Rizchel Anne B.

    BASIC SENTENCE PATTERNS

    BASIC SENTENCE PATTERNS

    Guillermo, Rizchel Anne B. · 10問 · 2年前

    BASIC SENTENCE PATTERNS

    BASIC SENTENCE PATTERNS

    10問 • 2年前
    Guillermo, Rizchel Anne B.

    PRONOUN-Antecedent

    PRONOUN-Antecedent

    Guillermo, Rizchel Anne B. · 24問 · 2年前

    PRONOUN-Antecedent

    PRONOUN-Antecedent

    24問 • 2年前
    Guillermo, Rizchel Anne B.

    COLLABORATION!

    COLLABORATION!

    Guillermo, Rizchel Anne B. · 17問 · 2年前

    COLLABORATION!

    COLLABORATION!

    17問 • 2年前
    Guillermo, Rizchel Anne B.

    TEAM STRUCTURE AND DYNAMICS FOR ICT CONTENT

    TEAM STRUCTURE AND DYNAMICS FOR ICT CONTENT

    Guillermo, Rizchel Anne B. · 11問 · 2年前

    TEAM STRUCTURE AND DYNAMICS FOR ICT CONTENT

    TEAM STRUCTURE AND DYNAMICS FOR ICT CONTENT

    11問 • 2年前
    Guillermo, Rizchel Anne B.

    ONLINE COLLABORATIVE TOOLS

    ONLINE COLLABORATIVE TOOLS

    Guillermo, Rizchel Anne B. · 19問 · 2年前

    ONLINE COLLABORATIVE TOOLS

    ONLINE COLLABORATIVE TOOLS

    19問 • 2年前
    Guillermo, Rizchel Anne B.

    BENEVOLENCE STORIES

    BENEVOLENCE STORIES

    Guillermo, Rizchel Anne B. · 47問 · 2年前

    BENEVOLENCE STORIES

    BENEVOLENCE STORIES

    47問 • 2年前
    Guillermo, Rizchel Anne B.

    a def pt 2

    a def pt 2

    Guillermo, Rizchel Anne B. · 34問 · 2年前

    a def pt 2

    a def pt 2

    34問 • 2年前
    Guillermo, Rizchel Anne B.

    GLOBALISASYON

    GLOBALISASYON

    Guillermo, Rizchel Anne B. · 42問 · 2年前

    GLOBALISASYON

    GLOBALISASYON

    42問 • 2年前
    Guillermo, Rizchel Anne B.

    KASAYSAYAN

    KASAYSAYAN

    Guillermo, Rizchel Anne B. · 17問 · 2年前

    KASAYSAYAN

    KASAYSAYAN

    17問 • 2年前
    Guillermo, Rizchel Anne B.

    2ND MIDTERMS

    2ND MIDTERMS

    Guillermo, Rizchel Anne B. · 16問 · 2年前

    2ND MIDTERMS

    2ND MIDTERMS

    16問 • 2年前
    Guillermo, Rizchel Anne B.

    TUGON

    TUGON

    Guillermo, Rizchel Anne B. · 23問 · 2年前

    TUGON

    TUGON

    23問 • 2年前
    Guillermo, Rizchel Anne B.

    GLOBALISASYON (pt. 2)

    GLOBALISASYON (pt. 2)

    Guillermo, Rizchel Anne B. · 44問 · 2年前

    GLOBALISASYON (pt. 2)

    GLOBALISASYON (pt. 2)

    44問 • 2年前
    Guillermo, Rizchel Anne B.

    2ND MASTERY

    2ND MASTERY

    Guillermo, Rizchel Anne B. · 23問 · 2年前

    2ND MASTERY

    2ND MASTERY

    23問 • 2年前
    Guillermo, Rizchel Anne B.

    10TYPES OF PLAGIARIM

    10TYPES OF PLAGIARIM

    Guillermo, Rizchel Anne B. · 12問 · 2年前

    10TYPES OF PLAGIARIM

    10TYPES OF PLAGIARIM

    12問 • 2年前
    Guillermo, Rizchel Anne B.

    3 TYPES OF WRITING PROCESS

    3 TYPES OF WRITING PROCESS

    Guillermo, Rizchel Anne B. · 15問 · 2年前

    3 TYPES OF WRITING PROCESS

    3 TYPES OF WRITING PROCESS

    15問 • 2年前
    Guillermo, Rizchel Anne B.

    CRITIQUE PAPER

    CRITIQUE PAPER

    Guillermo, Rizchel Anne B. · 31問 · 2年前

    CRITIQUE PAPER

    CRITIQUE PAPER

    31問 • 2年前
    Guillermo, Rizchel Anne B.

    SOIL HORIZON and TYPE OF SOIL

    SOIL HORIZON and TYPE OF SOIL

    Guillermo, Rizchel Anne B. · 14問 · 2年前

    SOIL HORIZON and TYPE OF SOIL

    SOIL HORIZON and TYPE OF SOIL

    14問 • 2年前
    Guillermo, Rizchel Anne B.

    WATER RESOURCES

    WATER RESOURCES

    Guillermo, Rizchel Anne B. · 17問 · 2年前

    WATER RESOURCES

    WATER RESOURCES

    17問 • 2年前
    Guillermo, Rizchel Anne B.

    INTRO, PROCESS AND FACTORS OF SOUL FORMATION

    INTRO, PROCESS AND FACTORS OF SOUL FORMATION

    Guillermo, Rizchel Anne B. · 17問 · 2年前

    INTRO, PROCESS AND FACTORS OF SOUL FORMATION

    INTRO, PROCESS AND FACTORS OF SOUL FORMATION

    17問 • 2年前
    Guillermo, Rizchel Anne B.

    CHARACTERISTICS OF SOIL/ HUMAN ACT IMPACT SOIL QUAL

    CHARACTERISTICS OF SOIL/ HUMAN ACT IMPACT SOIL QUAL

    Guillermo, Rizchel Anne B. · 8問 · 2年前

    CHARACTERISTICS OF SOIL/ HUMAN ACT IMPACT SOIL QUAL

    CHARACTERISTICS OF SOIL/ HUMAN ACT IMPACT SOIL QUAL

    8問 • 2年前
    Guillermo, Rizchel Anne B.

    soil deg, ways to conserve

    soil deg, ways to conserve

    Guillermo, Rizchel Anne B. · 14問 · 2年前

    soil deg, ways to conserve

    soil deg, ways to conserve

    14問 • 2年前
    Guillermo, Rizchel Anne B.

    問題一覧

  • 1

    DEFAULT SQL QUERY EDITOR:

    SELECT TOP (200) <column list> FROM [table_name]

  • 2

    CODE TO INSERT DATA: (3 columns and values)

    INSERT INTO [table_name] ( [column1], [column2], [column3] ) VALUES ( ‘value1’, ‘value2’, ‘value3’ )

  • 3

    4.2 CHANGING VALUES:

    USE [database_name] UPDATE [table_name] SET [column name] = ‘new value’ WHERE [column name] = ‘original value’;

  • 4

    4.2 CHANGE lastname ‘vergra’ to ‘vergara’:

    USE [database_name] UPDATE [table_name] SET lastname = ‘vergara’ WHERE lastname = ‘vergra’;

  • 5

    4.3 DELETE DATA

    USE [database_name] DELETE FROM [table_name] WHERE [column name] = ‘value’

  • 6

    4.3 DELETE ‘1008’ Column (it deletes not just the specific value you entered)

    USE [database_name] DELETE FROM [table_name] WHERE studentnumber = ‘1008’

  • 7

    4.4 - SQL Query TO VIEW THE CONTENT OF THE TABLE

    USE [database_name] SELECT * FROM [table_name]

  • 8

    4.5 VIEW TABLE - TOP 1000

    SELECT <column list> FROM [table_name]

  • 9

    4.5 IF YOU WANT TO DISPLAY SPECIFIC COLUMNS lastname, firstname, and middlename in ONE COLUMN

    SELECT studentnumber UPPER(lastname) + ‘, ‘ + UPPER(firstname) + SPACE(1) + UPPER(middlename) AS [new_column_name] FROM [table_name] SELECT column1 UPPER(column2) + ‘, ‘+ SPACE(1) + UPPER(column3) AS [new_column_name] FROM [table_name]

  • 10

    4.5 IN ASCENDING ORDER

    SELECT * FROM [table_name] ORDER BY lastname

  • 11

    4.5 IN DESCENDING ORDER

    SELECT * FROM [table_name] ORDER BY lastname DESC

  • 12

    4.5 ARRANGED BASED ON LASTNAME AND FIRSTNAME

    SELECT * FROM [table_name] ORDER BY lastname, firstname

  • 13

    YOU WANT TO SEE HOW MANY STUDENTS RESIDE IN CARMONA, CAVITE (address1 column name) (specific entry as value)

    SELECT * FROM [table_name] WHERE (address1 = ‘Carmona, Cavite’)

  • 14

    4.5 HOW MANY STUDENTS HAVE SAME ADDRESS AS HIS GUARDIAN (column as conditional value)

    SELECT * FROM [table_name] WHERE (address1 = [guardian address])