What are the parts of a sql statement?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of functions in sql?
Is grant a ddl statement?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
what does the t-sql command ident_current does? : Transact sql
What is $$ in sql?
have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
How do I run a script in sql developer?
How to select all records from the table?
what does myisamchk do? : Sql dba
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
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
How do you respond to dementia behavior?