how mysql optimizes distinct? : Sql dba


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what is denormalization. : Sql dba

0 Answers  


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

4 Answers   Adea,


What are dml commands?

0 Answers  


What is trigger in pl sql with examples?

0 Answers  


ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,






I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  


What is sql comments?

0 Answers  


Can we call dml statement in function?

0 Answers  


What is percent sign in sql?

0 Answers  


what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,


write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,


Can we write dml inside a function in sql server?

0 Answers  


Categories