Question : I understand how ORDER BY clause works and how the FIELD() function works. What i want to understand […]
Tag: fields
return field name and number of rows which meet condition in one sentence
Question : I have a table in postgres with 10 fields, and need to check for certain values in 3 […]
Product table with possible duplicate part numbers from different manufacturers
Question : I am making a database. It has a product(aka component or part) table with a ID, ManufacturerID, and […]
Multiple references to another table, but I don’t know how many
Question : I have two tables in a database, folowwing this model: scientists : id (int) | name (varchar) | […]
Efficiently write SELECT queries for tables with lots of columns (not SELECT *)
Question : Due to limitations in my GIS software, I need to write select queries for each of my 200+ […]
Identifying field changes between tables and consecutive rows
Question : I need to build an audit report to identify field changes between two tables, as well as between […]
How can I copy the definition of a field from one table to another at design-time?
Question : I have a table with ten fields, f1 (being an integer field) to f10 (being a character field). […]
Multiple references to another table, but I don’t know how many
Question : I have two tables in a database, folowwing this model: scientists : id (int) | name (varchar) | […]
Should I split these fields or leave as one?
Question : I want to create a database listing characters in each book of the A Song of Ice and […]
Should fields that are set to Not Null also have a constraint refusing empty strings?
Question : Any field that I would expect a value (Like an orderNumber or customerNumber) I would set as not […]
- 1
- 2