If you want to return the last value of any particular column then you use last funcion
syntax:
select last(empname) as lastname from emp;
when you run the above SQL command SQL will return the last value of the empname column from the emp table.
syntax:
select last(empname) as lastname from emp;
when you run the above SQL command SQL will return the last value of the empname column from the emp table.
No comments:
Post a Comment