Software Testing

k2G9Eo9
RdZQRt6

Popular Posts

FIRST


The FIRST() Function returns the First value of a selected column.
The basic syntax is as follows:
SELECT FIRST(Column_Name) FROM Table_Name
Employee
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

Syntax For SQL:
SELECT Emp_id, Name, Surname, FIRST(Salary), Dept_id FROM Employee
After Execute: 
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

No comments:

Post a Comment