Answer Posted / vishwa
below query will get the last day of the month
select last_day(sysdate) from dual
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is dml statement?
What is schema in sql?
What is the difference between numeric and autonumber?
What is mutating error?
what are the 'mysql' command line options? : Sql dba
What is a data manipulation language?
How do sql triggers work?
How do I get sql certification?
Why having clause is used in sql?
What are the types of records?
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 are the methods of filing?
Write a sql query to find the names of employees that begin with ‘a’?
What are the differences between implicit and explicit cursors?
What are the rules to be applied to nulls whilst doing comparisons?