Select all data but show top by latest datetime and current city wise

Question

5.00/5 (1 vote)

See more:

SQL-server-2000

SQL-Server-2005

, +

Suppose User is looking a website from kolkata and If user search the content then data will appear by latest datetime wise and by current city kolkata(Current Place).

What I have tried:

I have tried select query with multiple order by clause

select * from TABLE order by date desc, city desc

Posted 1-Apr-16 21:30pm

itsathere

Updated 1-Apr-16 22:39pm

v3

Add a Solution

Comments

Karthik_Mahalingam 2-Apr-16 3:43am

you mean to say, display kolkata data first followed by other city data ?

itsathere 2-Apr-16 4:01am

Yes.

Karthik_Mahalingam 2-Apr-16 4:08am

ok. you will be getting the kolkata value from the geo location rite?

itsathere 2-Apr-16 4:12am

No, from database. I think it does't matter.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2016-04-01T22:39:00

Solution 1

try this

SQL

select * , 'key' = 'a' from city where CityName = 'kolkata'   
union all
select * ,'key' = 'b' from city where CityName <> 'kolkata'  order by 'key', DateColumn desc

Posted 1-Apr-16 22:39pm

Karthik_Mahalingam

v2

Comments

itsathere 2-Apr-16 9:51am

what is 'key'='a'

Karthik_Mahalingam 2-Apr-16 9:54am

it is for reference to do the sorting.. you can ignore this column while selecting data from the query.

itsathere 2-Apr-16 10:03am

Explain please.

Karthik_Mahalingam 2-Apr-16 10:07am

see, if we do order by DateColumn desc
it wont consider the city, rather it will fetch all the data with date in descending order, to avoid that i have introduced a new column key to separate the two results.
run and see with and without key, you will find the difference..

itsathere 2-Apr-16 10:09am

Yes, Its working.Thanks for explanation.

Karthik_Mahalingam 2-Apr-16 10:10am

welcome