Download to read offline
MN
Uploaded bymohammed najim
PPTX, PDF255 views
Database testing in postgresql query
This document discusses database concepts like creating a database and tables, retrieving data through queries using SELECT, WHERE, ORDER BY, and aggregate functions like COUNT, AVG, MAX, MIN and SUM. It also covers updating, inserting, and deleting data through queries using UPDATE, SET, WHERE, INSERT INTO, VALUES, DELETE FROM, and creating temporary tables. The last line mentions copying data from a CSV file into a database table.
Database testing in postgresql query
- 10.
- 12. Retrieve the listof locations, ids, and observers in KS sorted by observer's last name. • SELECT FROM WHERE AND ORDER BY
- 13.
- 14. Eg: UPDATE SET WHERE • Eg:INSERT INTO • VALUES
- 15. Eg: DELETE FROM WHERE •Eg: CREATETEMP • SELECT * FROM • WHERE
- 16. copy FROM delimiter',' csv header ;