How can you sort dates?



How can you sort dates?..

Answer / pg

select <date column> from <table name> order by <date
column>

if needed in descending order
select <date column> from <table name> order by <date
column> desc

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More JDBC Interview Questions

is that compulsory to have Primarykey-forignkey for joints (outer inner,equal)

2 Answers   IonIdea,


write a query to select name from one table which has id,name and salary from another table which has id, sal where the salary is the second maximum

3 Answers   Bosch, HireCraft, Infosys,


What are the three parts of a jdbc url?

0 Answers  


How the information about db(database) can be retrieved?

3 Answers  


What is the different between ResultSet and RowSet?

0 Answers  






Does sql allow null values ?

0 Answers  


What is a PreparedStatement?

3 Answers   Infosys,


What do you mean by batch processing in jdbc?

0 Answers  


What are the different types of classes in the api component?

0 Answers  


What are the common tasks of JDBC?

0 Answers  


How to get the data from a table into a buffer?

2 Answers  


Why jdbc is used in java?

0 Answers  


Categories