Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
5 9706need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
2 5134i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
8 8116write 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 4715wirte 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 11629write 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 6637wirte 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 13582In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
JDA,
4 7118
Is a table valued function object?
Does postgresql run on the cloud?
What is the difference between view and stored procedure?
what does the t-sql command ident_current does? : Transact sql
Does a join table need a primary key?
explain mysql aggregate functions. : Sql dba
How exception is different from error?
How do you optimize a query?
What is clause?
What is union and union all keyword in sql?
What is basic structure of pl sql?
Is like operator in sql case sensitive?
how to use regular expression in pattern match conditions? : Sql dba
What is sqlcontext?
what is the difference between group by and order by in sql? : Sql dba