What is java sql package?
Can we write dml inside a function in sql server?
what are the advantages of mysql in comparison to oracle? : Sql dba
Why we use stored procedure instead of query?
List out the acid properties and explain?
What is cost in sql execution plan?
What is integrity in sql?
define join and explain different type of joins? : Sql dba
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
What is data profiling in sql?
i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6
Is clustered index a primary key?
Can we use joins in subquery?