Interested to Buy Any Domain ? << Click Here >> for more details...
How can u find column name from a table which have max value
in a row.( not max value)
- 5 Answers
- 7668 Views
- I also Faced
- E-Mail Answers
Answer Posted / ganesh
create table aa_test(
a number,
b number,
c number)
;
select greatest(a,b,c) from aa_test where a=99 ;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a native sql query?
what is a view? : Sql dba
Explain the select statement in sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
what is meant by urlencode and urldocode? : Sql dba
Is pl sql and postgresql same?
How many row comparison operators are used while working with a subquery?
What are sql functions? Describe the different types of sql functions?
What is sql injection owasp?
what are all different types of collation sensitivity? : Sql dba
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 to drop an existing view in mysql? : Sql dba
What is a pdo connection?
what are the advantages and disadvantages of views in a database? : Sql dba
Can we join 3 tables in sql?
