Useful tips for everyday
Can we delete a row from a table based on another table? Deleting rows based on another table. Sometimes we need to delete rows based…
How do you get the first weekday of the month? The EOMONTH function returns the last day of the month prior to the date in…
How to select count ( * ) from two different tables? How can I select count (*) from two different tables (call them tab1 and…
Why is Io stall writes so much higher? In particular, look inside of perfmon at the Physical Disk:Avg Disk Sec/Read and Avg Sec Disk Sec/Write…
How do I create a user login in SQL? To create a new user with system administrator rights, perform the following steps: In the Object…
How to find row count for all your tables in Postgres? Executing select count_em_all (); should get you row count of all your tables. I…
How to use one column data in like query? My problem is to use one column of table with LIKE statement. Query above results error…
How do you prevent duplicate records in Salesforce trigger? trigger PreventDuplicateContacts on Contact (before insert) { Set emailSet = new Set(); Set phoneSet = new…
What features can be extracted from an image? Features are parts or patterns of an object in an image that help to identify it. For…
How do you evaluate a clustering performance? Clustering quality There are majorly two types of measures to assess the clustering performance. (i) Extrinsic Measures which…