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
- 7462 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 are the advantages of pl sql?
what is normalization? : Sql dba
What does where 1/2 mean in sql?
What is posting?
How to sort the rows in sql.
What is insert command in sql?
How do I know if I have sql express or standard?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
which types of join is used in sql widely? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is primary key and foreign key?
What is union?
What is scalar data type in pl sql?
What is pl sql script?
