ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
   
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How can u find column name from a table which have max value
in a row.( not max value)
 Question Submitted By :: Anil Verma
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can u find column name from a table which have max value in a row.( not max value)
Answer
# 1
user greatedt function.

Ex select greatest(sal,bonus) from emp where emp_id = 1000;
 
Is This Answer Correct ?    0 Yes 4 No
Prashanth
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
What is Difference between StoredProcedure and function?  3
How would you hide a table in sql. ie the table can be only visible to its maker?  3
I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.  1
if i perform any operation on views such as insert, delete etc will my base table get affected?????  4
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh TCS2
how to create object in plsql Microsoft3
What are the different types of joins and explain them briefly.  3
hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?  5
Explain how procedures and functions are called in a PL/SQL block ?  2
what is global table iFlex5
How many rows will return from dual table? Fujitsu3
How do you handle exceptions. Give the syntax for it? Microsoft1
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com