SQL
RDBMS (Database) software are used to store the data. Formally known RDBMS (Relational Database Management System) Informally known Database 1) MySQL 2) Oracle 3) Sybase 5) Postgre and there are many more SQL (Structure query langauge) is used to to work around these RDBMS or Database SQL is pronounced as "sequel" Q: write a SQL to select all student ? SELECT * FROM student; Q: write a SQL to select only firstname of all students ? SELECT firstname FROM student; Q: write a SQL to select only surname of all students ? SELECT surname FROM student; Q: write a SQL to select only firstname and fathername of all students ? SELECT firstname, fathername FROM student; Q: write a SQL to select all students whose fathername is "akbar" ? SELECT * FROM student WHERE fathername = "akbar"; Q: write a SQL to select all students whose class is graeter than or equal to 5 ? SELECT * FROM student WHERE class >= 5; Q: write a SQL to insert a new student record ? INSERT...
thanks
ReplyDelete