Category Archives: h2 Database

H2 Database – Select Select command is used to fetch record data from a table or multiple tables. If we design a select query, then it returns data in the form of result table called result sets. Syntax The basic syntax of SELECT statement is as follows − SELECT [ TOP term ] [ DISTINCT […]

H2 Database – Update The UPDATE query is used to update or modify the existing records in a table. We can use WHERE clause with UPDATE query to update the selected rows, otherwise all the rows would be affected. Syntax Following is the basic syntax of the UPDATE query. UPDATE tableName [ [ AS ] […]

H2 Database – Delete The SQL DELETE query is used to delete the existing records from a table. We can use WHERE clause with DELETE query to delete selected records, otherwise all the records will be deleted. Syntax Following is the generic query syntax of the delete command. DELETE [ TOP term ] FROM tableName […]