Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT Roorkee
Apply NowSyntax:
select field1, field2,...fieldN
[from table_name1, table_name2...]
[where clause]
[limit [offset M ][limit N]]
When selecting a fixed value, FROM clause is not mandatory.
select 'Hello';
SELECT examples:
select * from deptt;
select d.* from deptt d;
select * from deptt d;
select depid, depname, depcity from deptt limit 1;
select depid, depname, depcity from deptt limit 1,2; -- skip 1 and return only 2 rows
Aliases
Tables and Columns can be given alias names for easy readability.
select e.empfname "First Name" from emp e;
Selecting unique values
Values in columns of a table may repeat across the rows of the table. To get unique values, use select distinct.
select distinct empfname from emp;
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...