Featured
-
No Featured Found!
Tags
Combine the PL/SQL and the SQL commands in manipulating the database.
(PL/SQL structure, Data types, Variable, DBMS Output and Conditions), try to combine the PL/SQL and the SQL, where you can use PL/SQL with SQL commands in manipulating the database. and this is my codes but i am having issues running it...
How to Use Calculation of an Aggregate Function as Filter Criteria?
I have tables on booking orders for trips.
Bookings (booking_id, booking_time, driver_id, customer_id)
Drivers (driver_id, name)
I need to identify all customers who have had at least 60% of their bookings completed by the same driver within t...
How to return order_no where customers made concurrent bookings?
I have a table on booking orders for trips.
Bookings (order_no, user_id, booking_time,cancel_time,complete_time)
I try to write a query to return the order_no from all rows where customers made concurrent bookings (i.e. where a customer mad...
Problems in writing sql queries anyone who can write following queries?
1. List all the directors who directed a film in a leap year by using SELECT statement
2. Find the film(s) with the largest cast using SELECT statement
3. Find all actors who acted only in films before 1960 using SELECT state...
How to Delete Duplicates from Tables with Relationship
http://stackoverflow.com/questions/58952607/trying-to-delete-duplicates-from-tables-with-relationship
I would like to know how to delete duplicate cases in a database with tables that are joined through the use of primary key and a f...
Is It Possible to Put all Upcoming to Mobirise eMail to Separate Database?
I receive a huge amount of messages from my landing page, created in Mobirise website builder. It's a mess.
I want to put them in a separate database, so I could see them in an order. Is it possible? I didn't find an answer i...
How to Merge XML CTE's in SQL Server Using Common Refid Key
I have the following CTE's, and I'm trying to combine XML1 and XML2 CTE's in Sql Server by their common refid key.
;With TBL1_Fruits As
(Select '1' as refid,
'Apples' as fruits,
'Red' a...
Why am I getting null values for lease_id in Rent?
Passing primary key values in the parent table to foreign key values in child table with parent insert and child insert being in separate stored procedures.
Parent is Lease table, the child is Rent table. I am getting null value...
