Рет қаралды 3,347
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:
info@cloudchallengers.com
Follow us on
Instagram : cloudchallengers
Facebook : cloudchallengers
LinkedIn : linkedin.com/company/cloudchallengers