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 create a database in pgadmin 3?

830

What is the purpose of postgresql?

751

Is mysql a postgresql?

802

How do I rename a column in postgresql?

860

Is postgresql better than oracle?

779

How do I find the size of a postgres table?

800

What does information_schema contain?

766

What is self referencing foreign key?

741

Why do we need connection pooling?

748

What is default postgres port?

851

Is postgres a mpp?

885

What is difference between postgresql and mysql?

882

Is postgresql a programming language?

776

How do you create a foreign key in pgadmin 4?

777

What is the difference between oracle and postgresql?

893