7) Write a query to add a unique constraint to the column Email, and a check constraint with a constraint named CHK_CONTACT to the column Contact_No to ensure that the contact number should accept only 10 digits in the customer table.
45) Write a query to display the courier details such as courier id, from address, to address and the status of the couriers delivered in the month of 'January'. Sort the records based on to address in ascending order.
Comments
Post a Comment