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

What is a postgres server?

414


How do I stop postgresql server?

445


What does information_schema contain?

424


What is foreign key in access?

434


How to execute postgres function in pgadmin?

602






Is postgresql better than mongodb?

445


What is schema in reading comprehension?

423


Why mysql is more popular than postgresql?

402


Does google use postgresql?

421


How do I connect to postgresql server?

420


What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

916


Does toad work with postgres?

411


How to display error message in postgresql?

453


Is primary key indexed by default?

431


What is foreign key violation?

430