Empowering coders, one solution at a time
Empowering coders, one solution at a time
SQL is the standard language for dealing with Relational Databases. SQL can be used to insert, search, update, and delete database records. SQL can do lots of other operations, including optimizing and maintenance of databases. This post will help you to…
1. Create a view named ‘building_details’ to display all the details of building. 2. Create a view named ‘building_owners’ to display all the owners of the building. 3. Create a view named ‘owner_details’ to display the owner name and contact number of the buildings having length of the owner name greater than 15. 4.…
1. Write a query to display the entire contents of the ‘electricity_connection_type’.Display the records in ascending order based on their connection name. select * from electricity_connection_type order by connection_name 2. Write a query to display the entire contents of the…
Write a query to change the due_date ‘2018-01-01’ to ‘2018-01-09’ in the bill table.
Write a query to display the second maximum payable amount who paid by the owner .Give an alias name to the second maximum payable amount as ‘second_max_payable_amount‘. Output: SECOND_MAX_PAYABLE_AMOUNT 724500
Write a query to display the second minimum fine amount from bill.Give an alias name to the second minimum fine amount as ‘second_min_fine_amount’. Output: SECOND_MIN_FINE_AMOUNT 472.5