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 19744 6892
What will be the output for the below Query Select 'High' from dual where null = null;12 19725
need 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 4029
i 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 subject8 6050
how many no of table can be join in a sql query.4 6821
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
wirte 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
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
wirte 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-20105 10268
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)8 9884
In 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
Define SQL and state the differences between SQL and other conventional programming Languages?
Why are cursors used?
what is schema? : Sql dba
what is 'mysqlimport'? : Sql dba
how would you enter characters as hex numbers? : Sql dba
What is the purpose of cursors in pl/sql?
How do I get sql certification?
What is partition by in sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can a composite key be null?
Why partition by is used in sql?
Does pl sql work in mysql?
what is the stuff function and how does it differ from the replace function? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
How to write a query to show the details of a student from students table whose