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 22013Interchange 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 18947What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 18953I 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 11569Post New Cap Gemini SQL PLSQL Interview Questions
Which animal is hyena family eats insects?
Is it possible to disable the tax calculation?
What is the hottest part of flame in fire?
Why is tomcat called catalina?
How does internet of things ( iot ) vary from industrial internet of things ( iiot ) ? Give benefits of iiot.
What is a nullreferenceexception and how do I fix it?
what is the hint? how to use it to reduce the query processing in program?
Describe the purposes and advantages stored procedure?
hi every one, i want to make a coal grinder to mil 3 or 4 tons of coal dust per hour . if you guys help me with photos or some tecnical drawings that would be very kind of you.
what are the possible test cases for online jobs search portal..if its a job seeker module and any 1 if u had worked on this proj pls share the bugs with sev and priority pls frends i need replies for these queries ..thanks in advance
Is impala intended to handle real time queries in low-latency applications or is it for ad hoc queries for the purpose of data exploration?
Explain how do you connect to sql server database without using sqlclient?
Can we store images in mysql database?
How many types of installations?
How do you control the spring life of a bean?