get second maximum date from tables.



get second maximum date from tables...

Answer / 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

More Postgre Interview Questions

Explain about Multi version concurrency control?

1 Answers  


How many rows can postgres handle?

0 Answers  


How to execute a function in postgresql?

0 Answers  


What happens to index when table is dropped?

0 Answers  


What does the option psql -l of PostgreSQL display?

0 Answers  


How to create table in particular schema in postgresql?

0 Answers  


How do I set up pgadmin?

0 Answers  


Is postgresql free to use?

0 Answers  


Is postgres a sql database?

0 Answers  


What is schema in reading comprehension?

0 Answers  


How to drop all tables in postgresql?

0 Answers  


How do I drop a table in postgresql?

0 Answers  


Categories