Interview Question
Country: United States
CREATE TABLE IF NOT EXISTS `row` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cource` varchar(255) NOT NULL, `specialization` varchar(255) NOT NULL, `institute` text NOT NULL, `graduation_year` int(11) NOT NULL, `aggrigate_marks` float(3,2) NOT NULL, PRIMARY KEY (`id`) )
Select * from row order by year asc
- WenjieWuChem August 22, 2015