one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
13 14839Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
3 13880What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 14791I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.
3 7455Post New Cap Gemini SQL PLSQL Interview Questions
What do you think holds testers back to do automation? Is there a way to overcome it?
How do I convert pages to docx?
What is the significance of “action 0” in qtp?
Mobile on Rupees 2000 purchase for office use not for staff....What entry in accounts..?????
What is rpf in networking?
While we are doing data migration, how you upload partially closed invoices.
Explain about the risk management function in sap gts?
Why is my chrome out of date?
Why is jit so fast?
How do you you calculate percentages in excel?
What is the command syntax that tells you whether you are on the master server or not? And how many master does mongodb allow?
How to run an xml file?
What is a system 32?
What all reports can be used to generate dashboards? : salesforce reports and dashboards
How do I view tables in mysql workbench?