Mysql Fourth Maximum Salary And 5th Maximum Salary

Mysql Fourth Maximum Salary AND 5th Maximum Salary 

Hi Today Discussed Mysql Fourth Maximum Salary and 5th Maximum Salary How to Get Select Query is just a easy way select query and then count max salary follows query.

Mysql Four Maximum Salary And 5th Maximum Salary 

Second Maximum Salary

SELECT 
    name, Salary
FROM
    emp a
WHERE
    1 = (SELECT 
            COUNT(name)
        FROM
            emp b
        WHERE
            b.Salary> a.Salary);

Third Maximum Salary

SELECT 
    name, Salary
FROM
    emp a
WHERE
    2 = (SELECT 
            COUNT(name)
        FROM
            emp b
        WHERE
            b.Salary> a.Salary);

Fourth Maximum Salary

SELECT 
    name, Salary
FROM
    emp a
WHERE
    3 = (SELECT 
            COUNT(name)
        FROM
            emp b
        WHERE
            b.Salary> a.Salary);

5th Maximum Salary

SELECT 
    name, Salary
FROM
    emp a
WHERE
    4 = (SELECT 
            COUNT(name)
        FROM
            emp b
        WHERE
            b.Salary> a.Salary);

List of Timezone GMT Database Query Mysql

List of Timezone GMT Database Query Mysql

Hi Today Discussed List of Timezone GMT Database Query Mysql normally php mysql basic database country timezone and state city this basic normally database stored so timezone database followes queries.

List of Timezone GMT Database Query Mysql

CREATE TABLE `zone` (
  `id` int(11) NOT NULL,
  `country_code` varchar(255) NOT NULL,
  `zone_name` text NOT NULL,
  `status` int(11) NOT NULL COMMENT '0-inactive 1-active'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Database Value

INSERT INTO `zone` (`id`, `country_code`, `zone_name`, `status`) VALUES
(1, 'Pacific/Kwajalein', '(GMT -12:00) Eniwetok, Kwajalein', 0),
(2, 'Pacific/Samoa', '(GMT -11:00) Midway Island, Samoa', 0),
(3, 'Pacific/Honolulu', '(GMT -10:00) Hawaii', 0),
(4, 'America/Anchorage', '(GMT -9:00) Alaska', 0),
(5, 'America/Los_Angeles', '(GMT -8:00) Pacific Time (US & Canada) Los Angeles, Seattle', 0),
(6, 'America/Denver', '(GMT -7:00) Mountain Time (US & Canada) Denver', 0),
(7, 'America/Chicago', '(GMT -6:00) Central Time (US & Canada), Chicago, Mexico City', 0),
(8, 'America/New_York', '(GMT -5:00) Eastern Time (US & Canada), New York, Bogota, Lima', 0),
(9, 'Atlantic/Bermuda', '(GMT -4:00) Atlantic Time (Canada), Caracas, La Paz', 0),
(10, 'Canada/Newfoundland', '(GMT -3:30) Newfoundland', 0),
(11, 'Brazil/East', '(GMT -3:00) Brazil, Buenos Aires, Georgetown', 0),
(12, 'Atlantic/Azores', '(GMT -2:00) Mid-Atlantic', 0),
(13, 'Atlantic/Cape_Verde', '(GMT -1:00 hour) Azores, Cape Verde Islands', 0),
(14, 'Europe/London', '(GMT) Western Europe Time, London, Lisbon, Casablanca', 0),
(15, 'Europe/Brussels', '(GMT +1:00 hour) Brussels, Copenhagen, Madrid, Paris', 0),
(16, 'Europe/Helsinki', '(GMT +2:00) Kaliningrad, South Africa', 0),
(17, 'Asia/Baghdad', '(GMT +3:00) Baghdad, Riyadh, Moscow, St. Petersburg', 0),
(18, 'Asia/Tehran', '(GMT +3:30) Tehran', 0),
(19, 'Asia/Baku', '(GMT +4:00) Abu Dhabi, Muscat, Baku, Tbilisi', 0),
(20, 'Asia/Kabul', '(GMT +4:30) Kabul', 0),
(21, 'Asia/Karachi', '(GMT +5:00) Ekaterinburg, Islamabad, Karachi, Tashkent', 1),
(22, 'Asia/Calcutta', '(GMT +5:30) Bombay, Calcutta, Madras, New Delhi', 0),
(23, 'Asia/Dhaka', '(GMT +6:00) Almaty, Dhaka, Colombo', 0),
(24, 'Asia/Bangkok', '(GMT +7:00) Bangkok, Hanoi, Jakarta', 0),
(25, 'Asia/Hong_Kong', '(GMT +8:00) Beijing, Perth, Singapore, Hong Kong', 0),
(26, 'Asia/Tokyo', '(GMT +9:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk', 0),
(27, 'Australia/Adelaide', '(GMT +9:30) Adelaide, Darwin', 0),
(28, 'Pacific/Guam', '(GMT +10:00) Eastern Australia, Guam, Vladivostok', 0),
(29, 'Asia/Magadan', '(GMT +11:00) Magadan, Solomon Islands, New Caledonia', 0),
(30, 'Pacific/Fiji', '(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka', 0);