There must be some column such as 'TECHNOLOGY' that should disti

I have one table,in that table
(1)i have java1.1 version books are 2 and java1.5 version
books are 4.
(2).Net2.0 books are 3, .Net3.5 books are 2
(3)ABC1.6 books are 4, ABC2.0 books are 3.

Now i want output is like

Book Count

Java 6
.Net 5
ABC 7

For this i need sql query, please help me if anyone how to
get this result.

Thanks,
Seenu

Question Posted / oraclecodec

4 Answers
6990 Views
Adea, I also Faced
E-Mail Answers

Answer Posted / oraclecodec

There must be some column such as 'TECHNOLOGY' that should
distinguish java ,.net and ABC apart from their versions.
Then its easier to arrive at a solution

SELECT TECHNOLOGY,COUNT(*) FROM BOOK GROUP BY TECHNOLOGY;

Is This Answer Correct ?

8 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to avoid using cursors?

1175

How many types of literals are available in pl sql?

1166

What are stuff and replace function?

1141

What is left inner join in sql?

1091

Is inner join same as self join?

1166

Is sql workbench free?

1043

What is cursor explain with example?

1028

What are sql constraints?

1226

What is cursor and why it is required?

1256

What is sql query limit?

1019

Explain the select statement in sql?

1181

Write a query to display the current date in sql?

1076

how to create a test table in your mysql server? : Sql dba

1055

What does data normalization mean?

1028

What is the difference between sql and t sql?

1105