write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35
TCS,
1 4725wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh
TCS,
6 11645write 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
TCS,
3 6645wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
6 13604If i entered 2 columns and 4 rows inputs in DDT Like Mango fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q is How to get the 2nd column value for corresponding 1 column input in 3rd row ie, ( i need to get "veget" in messge box @ run time
CTS,
5 7394write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
TCS,
2 4894write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
HP,
2 5251write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
4 8438write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
5 9811how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
CTC,
4 243861)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
18121)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?
2 5135
What do you mean by httpservlet and how it is different from the genericservlet?
how many type of indexing in database?
Explain the advantages of jquery?
What are the external command in dos?
What is a pipelinedrdd?
Tell the advantages of companion objects when used in scala?
How many types of views are there in ms powerpoint?
Why can't we use static class instead of singleton?
Can you prevent a class from being instantiated?
Tell the issues faced in weblogic?
How can I open ms word?
Is not null in sql?
What is the function and importance of the registry?
What is doubly linked list in c++?
What is syscat in db2?