sql query help needs :) - Digit Technology Discussion Forum

Forum

		Digit Technology Discussion Forum > Software > Programming
sql query help needs :)

Mark Forums Read

Programming The destination for developers - C, C++, Java, Python and the lot

Closed Thread

14-08-2008, 08:22 PM	#1 (permalink)
quad_master Tired of being sorry! Join Date: Jan 2008 Location: City of Joy Posts: 67	sql query help needs :) need some help!!! i try to display the top 2 rows of last 3 years every month!!! something like this: yr month name ======= ========= ========== 2008 jan ram . . . . . . 2008 dec ram1 2007 jan ram2 . . . . . . 2007 dec ram3 2006 jan ram4 . . . . . . 2006 dec ram5 im using a VIEW(from where i get data) & sql server.... plzzzz somebody help me... happy independance day!! __________________ There are 10 types of people in this world, those who understand binary and those who do not.

	Advertisements. Register and be a member of the community to get rid of them.
Advertisement

16-08-2008, 04:17 PM	#2 (permalink)
victor_rambo हॉर्न ओके प्लीज़ Join Date: Sep 2007 Posts: 1,493	Re: sql query help needs :) I don't get it with what you posted above! Give me a sample database structure and data.(give me in SQL form: CREATE TABLE... INSRRT INTO ....) __________________ विक्टर रॅंबो - चाणकया प्रभावित व्यक्ति गीक होना माँगता Last edited by victor_rambo; 16-08-2008 at 04:29 PM.

16-08-2008, 05:22 PM	#3 (permalink)
Bandu Broken In Join Date: Aug 2008 Location: Mumbai, India Posts: 169	Re: sql query help needs :) I never worked with SQL Server, but SQL Server does support something like select top x So, for you, won't a Code: Select top 2 from <YOUR_VIEW> work?

Closed Thread

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Query Help	enjoy	Software Q&A	2	08-09-2006 09:17 AM
query about hdd	kjuvale	QnA (read only)	15	11-01-2006 12:02 AM
UPS Query ! !	kaps_2222	Hardware Q&A	5	07-11-2005 10:54 PM
30 fps query	Tommygecko	Gamerz	1	22-05-2005 01:07 AM
Microtek Monitor Query and PHPBB Attachment Mod Query	vwad	Software Q&A	1	20-03-2005 09:32 AM

Latest Threads
Windows 8 Thread. - by Sujeet
Kingdom of Amalur: Reckoning discussion - by vamsi_krishna
Your Gaming Backlog/Progress Report! - by Ethan_Hunt
Should I buy Galaxy S2 now? - by techlover
Sony announces the water-proof Xperia go and Xperia acro S - by clmlbx
Letsbuy.com now integrated with Flipkart.com - by Terabyte
Dual Core Confusion!!!! - by rahulpv102
iOS 5.1.1 jailbroken.. - by Sujeet
Doom 3 BFG edition/ HD remake! - by cyborg47
Language learners' discussion thread !! :D - by icebags

Advertisement

All times are GMT +5.5. The time now is 11:09 AM.

Search Engine Optimization by vBSEO 3.3.2