how mysql optimizes distinct? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
what is denormalization. : Sql dba
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
What are dml commands?
What is trigger in pl sql with examples?
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.
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
What is sql comments?
Can we call dml statement in function?
What is percent sign in sql?
what is the difference between implicit and explicit trigger
write a qurey for finding the length of the sting.
Can we write dml inside a function in sql server?