select dateofjoining from employees group by dateofjoining order by dateof

get second maximum date from tables.

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

How do you edit a table in pgadmin?

818

Is postgresql a database?

888

What does postgresql do?

914

How to get current date in postgresql?

1031

Is primary key indexed by default in postgres?

844

How does db indexing work?

1004

What is the latest version of postgresql?

915

What is the default password for postgres windows?

915

What is the default postgres user?

846

How do I completely uninstall postgresql?

898

How to import sql file in postgresql pgadmin 4?

887

What is postgresql jdbc driver?

957

What is unlogged table?

819

What are the indices of postgresql?

960

What is join and how many types of joins?

869