Real Time SQL Interview Queries|| Technical Round || Top & Bottom Percentage ||

Поделиться
HTML-код
  • Опубликовано: 30 сен 2024
  • Adding DDL, DML commands:
    --------create table--------
    create table emp_rates(City varchar(50),State varchar(50),Population float,Employed float)
    --------Insert data---------
    insert into emp_rates values('Bangalore','KA',23.5,16.5)
    insert into emp_rates values('Chennai','TN',17.5,9.1)
    insert into emp_rates values('Hyderabad','TL',22.2,13.5)
    insert into emp_rates values('Mumbai','MH',35.3,21.9)
    insert into emp_rates values('Delhi','DL',25.4,13.8)
    insert into emp_rates values('Gurgaon','HR',12.9,9.7)
    insert into emp_rates values('Pune','MH',14.5,9.9)
    insert into emp_rates values('Noida','UP',11.6,8.8)

Комментарии • 1