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 19587Interchange 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.
4 17750What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 17618I 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.
4 10509Post New Cap Gemini SQL PLSQL Interview Questions
How are pointers type-cast?
What are the different types of elements present in economics?
What is .net mobile forms? : Microsoft dot net mobile
how can be the default page settings changed for a silverlight page ?
What is the maximum number of rows in access 2010?
What do I need to get rpc over http working?
How many structures are there?
please send the model written test papers to pandu476@rediffmail.com for ET
What is the difference between tuples and lists in python ?
What are the advantages of interface in c#?
areas for improvement
How do I consolidate duplicate rows in excel?
What do you mean by multithreading?
What is a parameter in java?
What kind of equipment do I need?