What does partition by mean in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How do I install sql?
If records are inserted into table without committing.How to refer to these values in a procedure?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is the difference between between and in condition operators?
How to read/write files from pl/sql?
What are the different types of joins and explain them briefly.
How do you write a subquery?
What is meaning of <> in sql?
What is gpt format?
What are the types of subqueries?
sales persons should always receive commission of 100 at least. employees who r not sales persons should never receive commission.(Triggers)
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
Oracle (3259)
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)