CodePudding
Home
front end
Back-end
Net
Software design
Enterprise
Blockchain
Mobile
Software engineering
database
OS
other
Home
>
Software engineering
▪ Improper calculation of a date difference in sql
▪ UsageError: Line magic function `%%bigquery` not found
▪ Latest value of compared date range? (SQL/Snowflake)
▪ Get records greater than 1 for same status
▪ SQL JOIN get all records that do not match certain criteria
▪ Oracle case statement not returning values for no row results
▪ Postgres - order records based on a property inside an array of json objects
▪ Find rows only with single character
▪ Converting nvarchar to int, converting phone with symbols with only numbers
▪ Extract items from JSON containing a nested array
▪ Why is this CREATE command not running?
▪ select sal from emp order by sal desc limit 1,1;
▪ Counting separate occurrences in a string T-SQL
▪ Build date from year and month with quarter
▪ SQL Tickets sold - Last 30 Days - use Where or Having?
▪ Perform two sums with different conditions
▪ Is there a reverse ISNULL() function in SQL Server?
▪ convert row values to single column as array (or to multiple columns)
▪ How to remove all letters from the beginning of the string in SQL server?
▪ Having difficulty generating distinct rows without duplicates in a SELF JOIN (SQL)
«
1869
1870
1871
1872
1873
1874
1875
1876
1877
1878
»
Links:
CodePudding