i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?
6 11777Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F
6 8451Interchange 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 17757have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.
8 11933i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 9609I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
1 2172Post New IBM SQL PLSQL Interview Questions
How do you track your progress in a sprint?
How do I remove a table in word but keep the text?
Differentiate between datastage and informatica?
Is India a mixed economy? What do you know about mixed economy?
how to embed flash in html? : Adobe flash
I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.
Why efficiency in thermal power plant is low?
Define the term “percolate down”?
What is Trade Recovery Estimate and how can we calculate it?
What is purpose of abstract class?
How to create a simple node js application?
Describe coalesce() operation. When can you coalesce to a larger number of partitions? Explain.
Do you know C or any other language?
Explain how to create custom 404 page in codeigniter?
What do you understand by avr?