Reply
  • Updated Dec 14, 2022

    help me out

  • Dec 14, 2022
    edited
    2 replies

    select KNOWLEDGE from ktt2 where sxn = LIFE

  • Dec 14, 2022
    ruckus
    路 edited

    select KNOWLEDGE from ktt2 where sxn = LIFE

    help bro

  • Dec 14, 2022
    2 replies

    What are you even asking for

  • Dec 14, 2022

    lol

  • Dec 14, 2022
    Yuzzy

    What are you even asking for

  • Dec 14, 2022
    3 replies
    Yuzzy

    What are you even asking for

    what sql program can i learn quickly that many offices use

  • Dec 14, 2022
    BIGGWAVE

    what sql program can i learn quickly that many offices use

    Program to do what?
    Do you mean a dialect of SQL? If so, I'd rec T-SQL but they're all generally same down to syntax

  • Dec 14, 2022
    1 reply
    BIGGWAVE

    what sql program can i learn quickly that many offices use

    SQL is a language for databases

  • Dec 14, 2022
    1 reply

    Wants to learn SQL, but can't do a basic Google search?

  • plants 馃尰
    Dec 14, 2022
    1 reply
    FKA Tadow

    Wants to learn SQL, but can't do a basic Google search?

    shambles off rip it's not looking too good but i have faith in him

  • Dec 14, 2022
    2 replies
    ks99

    SQL is a language for databases

    can you name me a common program that many offices use that use sql language?

  • Dec 14, 2022
    1 reply
    BIGGWAVE

    can you name me a common program that many offices use that use sql language?

    Microsoft SQL Server

  • Dec 14, 2022
    plants

    shambles off rip it's not looking too good but i have faith in him

    Yeah, at least he's trying

  • Dec 14, 2022
    1 reply
    BIGGWAVE

    what sql program can i learn quickly that many offices use

    Postgres, MSSQL, or Oracle

  • Dec 14, 2022
    2 replies
    ks99

    Microsoft SQL Server

    so people would enter commands to fetch data and you can also enter data in it also?

  • Dec 14, 2022
    designing

    Postgres, MSSQL, or Oracle

    ahhh yes thanks fam

  • Dec 14, 2022
    1 reply
    BIGGWAVE

    so people would enter commands to fetch data and you can also enter data in it also?

    have u got experience with microsoft access/excel

  • Dec 14, 2022
    1 reply
    ruckus

    have u got experience with microsoft access/excel

    yea i do
    would you consider excel a form of sql or no?

  • Dec 14, 2022
    BIGGWAVE

    yea i do
    would you consider excel a form of sql or no?

    no

    it鈥檚 a bit different like

    you鈥檙e entering data directly into a file with access/excel unless you use SQLite it does not behave the same

    honestly without knowing ur end goal it鈥檚 kinda hard to recommend what to do imo

  • Dec 14, 2022
    1 reply
    BIGGWAVE

    so people would enter commands to fetch data and you can also enter data in it also?

    You can upload data from your machine onto SQL
    You can connect to a server and read data from there

  • Dec 14, 2022

    You can write SQL programs but generally you'll use it for quick and dirty queries, acquiring information about data

  • Dec 14, 2022
    2 replies
    Yuzzy

    You can upload data from your machine onto SQL
    You can connect to a server and read data from there

    okay so when you use commands to fetch data you use it on the server right?

  • Dec 14, 2022
    BIGGWAVE

    okay so when you use commands to fetch data you use it on the server right?

    you send a request to a server and receive data from it, generally

  • Dec 14, 2022
    1 reply

    SELECT Products.ProductID,
    AVG(OrderDetails.UnitPrice (1 - DISCOUNT) ) AS AveragePriceReceived,
    Products.UnitPrice,
    (AVG(OrderDetails.UnitPrice
    (1 - Discount) ) - Products.UnitPrice) /
    AVG(OrderDetails.UnitPrice * (1 - Discount) ) AS PercentPriceDifference
    FROM OrderDetails
    INNER JOIN
    OrderHeaders ON OrderDetails.OrderID = OrderHeaders.OrderID
    INNER JOIN
    Products ON Products.ProductID = OrderDetails.ProductID
    WHERE OrderHeaders.OrderDate BETWEEN '2019-01-01' AND '2019-12-31'
    GROUP BY Products.ProductID;