What SQL keyword must immediately follow the UNION ALL
statement?
1. SELECT
2. INTO
3. ORDER
4. WHERE
5. JOIN
Answers were Sorted based on User's Feedback
What is percent sign in sql?
how to create a database in oracle?
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
what is a database lock ? : Sql dba
What is pl sql script?
What are the basic sql commands?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
How do you delete duplicates in sql query using rowid?
Explain the purpose of %type and %rowtype data types?
Is sqlite good enough for production?
What is application trigger?
Differentiate pl/sql and sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)