How do we tune the code?
Answers were Sorted based on User's Feedback
Answer / shobhit
we can tune our code as folllows
1:reducing no of lines in code
2: using indexes based columns in our sql select statements.
3: using the best logics
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / raaaa
tuning the code is complier the output than code is verify
Is This Answer Correct ? | 0 Yes | 4 No |
How to get each name only once from an employee table?
Why do we use subquery?
explain normalization concept? : Sql dba
How to update salary of employees department wise?
What are tables and fields in the database?
What is time based sql injection?
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
Suppose 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
what is msql? : Sql dba
how to use myisamchk to check or repair myisam tables? : Sql dba
Can you join views in sql?