I'm dealing with a project that requires me to query a MS SQL Server. Not
a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL
standard? MS SQL Server uses a TOP modifier.
select top 1 * from xxx;
Whereas all the SQL RDBMS' I've used before used
select * from xxx limit 1;
Any enlightenment is appreciated. (I'm putting notes in the code to
reflect the non-standard stuff I've had to deal with.)
TIA,
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match 3 2687
Rod,
Have a look at the bottom of this page: http://www.postgresql.org/docs/curre...ql-select.html
"Nonstandar d Clauses
The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
standard."
TOP x isn't in the standard as well, afaik.
Best regards,
Arjen
Roderick A. Anderson wrote: I'm dealing with a project that requires me to query a MS SQL Server. Not a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL standard? MS SQL Server uses a TOP modifier.
select top 1 * from xxx;
Whereas all the SQL RDBMS' I've used before used
select * from xxx limit 1;
Any enlightenment is appreciated. (I'm putting notes in the code to reflect the non-standard stuff I've had to deal with.)
TIA, Rod
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)
On Mon, 15 Dec 2003, Arjen van der Meijden wrote: "Nonstandar d Clauses
The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL standard."
Humm. Is there a SQL standard to return a subset of the selected tuples?
This being contrary to relational theory I believe. :-)
TOP x isn't in the standard as well, afaik.
I had no doubts there.
Thanks,
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org
On Mon, 15 Dec 2003 09:32:34 -0800, Roderick A. Anderson wrote: want to ask if the LIMIT modifier is SQL standard?
No. The standard doesn't have anything like that, unfortunately.
MS SQL Server uses a TOP modifier.
Yes, but it accepts an optional "WITH TIES" modifier which PostgreSQL
doesn't have.
See also: http://troels.arvin.dk/db/rdbms/#select-limit
--
Greetings from Troels Arvin, Copenhagen, Denmark
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: steve |
last post by:
Can someone give me an example of using the ’e’ pattern modifier in
php regex:
http://www.php.net/manual/en/reference.pcre.pattern.modifiers.php
Thanks in advance. Wish the manual had some examples on this one!
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/PHP-pattern-modifier-ftopict233538.html
|
by: Dan Disney |
last post by:
I have read conflicting information on the access scope
of VB.Net class declarations when no access modifier is
specified. MSDN library documentation states "Classes
that do not specify an access modifier are declared as
Friend by default" However, another source, VB.Net Class
Design Handbook by Wrox Press states that no a "no class
access modifier results in an implicit scope of public to
all assemblies". In fact, if I create a class...
|
by: N Khan via .NET 247 |
last post by:
Hi,
I know the usage of access modifier ?public? in DLL assembliesbut I am a bit puzzled that if let say I have a public class inan exe assembly then what purpose access modifier ?public? willserver. Related to the same thing is it possible that we canexpose exe assembly like DLL assembly.
Cheers
-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)
<Id>p7rsZMJSYEKKt7NbDTtJeA==</Id>
|
by: fh1996 |
last post by:
Documents say that "new" class modifier is only used with nested classes.
"new" indicates that the class hides an inherited member of the same name."
public class MyDerivedC : MyBaseC
{
new public void Invoke() {}
}
The only thing I don't understand in the above statement and example is that
it says that "new" only used with nested classes. However the example isn't
|
by: Aaron |
last post by:
Hi,
I am attempting to alter the behaviour of a base class using the new
modifier. I have hit a snag and am unable to hide the base class
member. The skeleton code is below, I have included an override class
derivation as well that does hide the member, why override does and
new doesn't I am not sure?
using System;
| |
by: Mark Kamoski |
last post by:
Hi--
Please help.
What is the default access modifier value for a Sub or a Function when one
has not explicitly been set.
In MSDN, in "Access Types", it states...
"If no access modifier has been specified, the default access type depends
|
by: Alan Foxmore |
last post by:
I understand about public, internal, protected, etc.
Is there a way to ensure members are accessible within the same
namespace only? In other words, I want to prohibit access to members
outside the namespace. Can this be done? I don't think so.
Thanks
--
Alan Foxmore
|
by: =?iso-8859-2?B?SmFuIFJpbmdvuQ==?= |
last post by:
Hello everybody,
this is my first post to a newsgroup at all.
I would like to get some feedback on one proposal I am thinking about:
--- begin of proposal ---
Proposal to add
signed/unsigned modifier to class declarations
to next revision of C++ programming language
|
by: muler |
last post by:
"If an instance method declaration includes the sealed modifier, it
must also include the override modifier." The C# Programming Language,
§ 10.5.5 Sealed Methods
Why is this?
Thanks,
Mulugeta
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |