get second maximum date from tables.
- 1 Answers
- 3524 Views
- I also Faced
- E-Mail Answers
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 |
More Postgre Interview Questions
How do you remove a foreign key constraint?
How do I connect to postgresql on windows?
What are spatial functions?
What are the data types in postgresql?
How to insert data from one table to another in postgresql?
How do you create a table in pgadmin?
Which key can be used to execute a query in the query editor?
Is primary key indexed by default in postgres?
Who invented postgresql?
What is postgresql dba?
How large can a postgresql database be?
How do you enter data in pgadmin4?
Categories
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
