472,371 Members | 1,615 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,371 software developers and data experts.

I found the answer

Thanks Ana,
That table was just an example to show what I want,
I want one record whenever value of field 1 change
while I sorted records based on value of field 2,
I know it's not a regular SQL question, anyway I
could find a way with Select/Sub-Select and with
Lead and Over (they are analytical functions).
Thanks anyway - Sasan
Jun 27 '08 #1
0 781

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: TimS | last post by:
I am getting a baffling File not found error (0x800A0035). I am writing asp on a windows 2000 server. I build a path and filename from several fields in a jet database using SQL commands, like...
by: Gidi | last post by:
hello, i was looking for this answer for something like a month and yesterday i found it. my problem was to register my dataGrid cells to event or to respond to events and what i did was to...
by: Frank | last post by:
Hello, I have usercontrol dll. If I reference it in the calling application with local copy=true it works fine. If I set local copy to false. I get an error saying the dll cannot be found. What do...
by: hendy | last post by:
Dear all, i'm using windows XP, IIS 5.1, Visual .NET 2003 and SQL Server 2000. When I open New Project - Visual C# Projects - ASP .NET Web Service - Location : http://localhost/WebService1 ...
by: =?Utf-8?B?S2VzdGZpZWxk?= | last post by:
Hi Our company has a .Net web service that, when called via asp.net web pages across our network works 100%! The problem is that when we try and call the web service from a remote machine, one...
by: tomb | last post by:
I am generating a form dynamically through AJAX. The form and the data come in very nicely, but my reset button doesn't do anything. There are 3 other buttons that call javascript functions - they...
by: pbrunson | last post by:
For two days I have tried every combination of code I could find / think of. I have a simple update I want to do to a field, but I am getting a data type miss match error when I set the WHERE to a...
by: ronnysaid | last post by:
Hi all, I was wondering if there is a way to get the range from the frozen panes in excel using interop v.12?? Or is there a property associated with the range indicating its frozen or not?? ...
by: dantebothermy | last post by:
Hi all: On Access 2003: I have a tabular form with labels next to the associated fields. I'd like them both to dissappear when the associated field is null. ("Can Shrink" will do this for the...
by: bmerlover | last post by:
Hello, I have written my code in Visual C++ using .NET Framework. I have several checkboxes on my GUI and I would like to give the user the option of saving the current state of the checkboxes. I...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.