Hero Motocorp SQL Interview Questions using REPLICATE(), RIGHT() and CONCAT() Functions

SQL questions recently asked in Motocorp interview. 1. We need to mask first 12 digits of card number. 2. Need to select employee names with same salary. Create table syntax CREATE TABLE cards (card_number BIGINT) INSERT INTO cards VALUES (1234567812345678),(2345678923456789),(3456789034567890) CREATE TABLE Employee (employee_id INT,ename VARCHAR(50),salary INT) INSERT INTO Employee VALUES (3, 'Bob', 60000),(4, 'Diana', 70000),(5, 'Eve', 60000),(6, 'Frank', 80000),(7, 'Grace', 70000),(8, 'Henry', 90000) For more SQL interview questions. Check out our playlist.    • SQL Interview Questions   Contact us: [email protected] Follow us on Instagram : instagram.com/cloudchallengers Facebook : facebook.com/cloudchallengers LinkedIn : linkedin.com/company/cloudchallengers