Ask the Experts

Ask the Experts

Oracle and SQL

  • The row with the latest date

    I have a database of millions of rows of trades. I want to retrieve the trade record of the latest buy trade. This would have the latest TRADE_DATE and the BSCODE = 'B.' How do I specify the latest TRADE_DATE?  Continue Reading

  • Compare values in consecutive rows

    I have a set of data in PostgreSQL with reading_timestamp as one of the columns and level as another column. I need to sort these data in ascending order (based on reading_timestamp) and then compare the value of level in two consecutive rows. If ...  Continue Reading

  • Oracle treats empty strings as NULL

    This is with reference to "NULL can be your friend." You suggest to use COALESCE function and say that "What this COALESCE expression does is substitute an empty string whenever foo is NULL, so that the resulting value will be found in the IN list....  Continue Reading

  • Calculate amount percentages

    I have a table with two columns, ID and amount. I need to calculate percentage amount allocated to an ID.  Continue Reading

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close