Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

How to sort two records between two dates without using between

This is a discussion on How to sort two records between two dates without using between within the SQL forums, part of the Databases category; How to sort two records between two dates without using between two records Question asked by visitor S.Ingale...

Geeks Talk > Databases > SQL How to sort two records between two dates without using between

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   07-18-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

How to sort two records between two dates without using between How to sort two records between two dates without using between two records Question asked by visitor S.Ingale

Sponsored Links

#2 (permalink)   07-19-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: How to sort two records between two dates without using between can u pass a few more details ,what exactly u are trying to do.

#3 (permalink)   07-19-2007

mannam07 Junior Member   Join Date: Jul 2007 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: How to sort two records between two dates without using between [quote=Geek_Guest;15240]How to sort two records between two dates without using between two records if you dont want to use between you can use < and >

#4 (permalink)   07-20-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: How to sort two records between two dates without using between try to use comparision operators .

#5 (permalink)   12-14-2007

indira.s Junior Member   Join Date: Dec 2007 Location: India Posts: 4 Thanks: 0 Thanked 0 Times in 0 Posts

Re: How to sort two records between two dates without using between Hi, you asked for sorting and it can be done using ORDER BY keyword. ORDER BY Bye.

Geeks Talk > Databases > SQL

« Select within select | Sum giving different results »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to find the diffrence berween two dates	reetasharma108	Data Warehousing	2	09-04-2007 08:20 AM
I want to sort out 200 to 300 records	Geek_Guest	Career Advice	0	06-10-2007 06:18 AM
which one is best to display records?	psuresh1982	SQL	2	05-11-2007 10:47 AM
Where are the error records located	Geek_Guest	Oracle Apps	0	03-01-2007 09:44 PM
With Joyce Audio Converter you can sort out all your audio files and make an ordered	JobHelper	Geeks Lounge	0	01-03-2007 02:02 PM

All times are GMT -4. The time now is 08:27 PM.