get second maximum date from tables.

Answer Posted / guest

select dateofjoining from employees group by dateofjoining
order by dateofjoining desc limit 1 offset 1;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you change columns in postgresql?

583


Does postgres have clustered index?

558


What does edb stand for?

740


How do I download postgresql on windows?

572


How to create a new table from existing table in postgresql?

605






How do I enable remote access to postgresql database?

549


How many indexes per table are allowed in postgresql?

565


What is connection limit in postgresql?

566


Is postgresql like oracle?

593


How many columns can a postgres table have?

578


Where is postgresql conf in mac?

671


Does postgres support clustering?

586


What is the operator that is used for case-insensitive regular expression searches in PostgreSQL?

1012


Is it postgre or postgres?

579


What is stack builder?

575