`
feipigwang
  • 浏览: 767632 次
  • 性别: Icon_minigender_2
  • 来自: 北京
文章分类
社区版块
存档分类
最新评论

SQL SELECT TOP N equivalent in ORACLE and MySQL

阅读更多

SQL SELECT TOP N equivalent in ORACLE and MySQL

Something I needed today... I wish this was standarized, but it is not, so here are some examples:

SQL Server:

SELECTTOP10product,descr,email
FROMproducts

ORACLE:

SELECTproduct,descr,email
FROMproducts
WHEREROWNUM<=10

MySQL:

SELECTproduct,descr,email
FROMproducts
LIMIT10
分享到:
评论

相关推荐

    微软内部资料-SQL性能优化3

    SELECT * FROM master.dbo.spt_values WHERE type = N'L' However, the req_mode column of master.dbo.syslockinfo has lock mode code that is one less than the code values shown here. For example, value ...

    MySql.Data.dll

    MySQL.Data.dll还支持高级特性,如预编译的SQL语句(用于防止SQL注入攻击)、异步操作(提高性能,特别是在网络延迟较高的情况下),以及对大型数据类型(如BLOB和TEXT)的支持。 总的来说,MySQL.Data.dll是Unity...

    Meaning and calculation of equivalent volume of electron cloud

    Meaning and calculation of equivalent volume of electron cloud,张涛,,The meaning of the equivalent volume of electron cloud was explained. Expressions for the equivalent volume of electron cloud ...

    Excel.2013.Working.with.Data.Ranges.and.Tables

    The Napier & Rivers courses Microsoft® Excel® 2013: Getting Started with Excel and Microsoft® Excel® 2013: Creating and Formatting Charts or the equivalent experience working with Excel 2013 in ...

    Modeling Derivatives in C++

    It is equivalent to Numerical Recipes in C but for derivative models. It is one of the most comprehensive and details books I've seen at roughly 900 pages. It shows not only the mathematical ...

    Seamless R and C++ Integration

    Attributes are built on top of Rcpp modules and their implementation is based on previous work in the inline package. See the Rcpp-atttributes vignettes for more details. Documentation The package ...

    Item selection via Bayesian IRT models

    Items that belong to the same groups can be considered equivalent in terms of both difficulty and discrimination power. According to decision criteria, we select a subset of items such that the ...

    Programming in Python 3 Second Edition

    Python is a very expressive language, which means that we can usually write far fewer lines of Python code than would be required for an equivalent application written in, say, C++ or Java....

    WPF and Silverlight MVVM

    In Chapter 1, WPF and Silverlight will be explored in some detail and their respective features highlighted. Chapter 2introduces the foundation of the MVVM pattern: the databinding model that ...

    Digital and Analogue Communication Systems 2012.

    Preemphasis and Deemphasis in Angle-Modulated Systems, 346 5–7 Frequency-Division Multiplexing and FM Stereo 348 5–8 FM Broadcast Technical Standards and Digital FM Broadcasting Digital FM ...

    statistics for business and economics

    #### 1.3 概率与统计推断(Probability and statistical inference) 概率论提供了处理不确定性问题的数学框架,而统计推断则是利用样本数据对总体参数进行估计和假设检验的过程。这部分内容对于理解如何从有限的...

    Design and Realization of Position Controller Based on Characteristic Model

    The position controller is constituted by an adaptive equivalent controller based on identification parameters and an improved sliding mode controller, and the stability of the closed-loop system is ...

    think in java pattern

    There is a chapter on design patterns in the first edition of Thinking in C++, which has evolved in Volume 2 of the second edition of Thinking in C++, and you’ll also find a chapter on patterns in ...

    Concepts in Electric Circuits

    **Voltage, Current Relationships for R, L, and C**: The behavior of resistors, inductors, and capacitors in AC circuits is different from their behavior in DC circuits. The impedance of these ...

    Seamless R and C++ Integration with Rcpp

    It is being used for anything from small and quickly constructed add-on functions written either to fluidly experiment with something new or to accelerate computing by replacing an R function with its...

    数据库系统基础教程ppt

    1 Introduction to Database Systems 1.1 The Evolution of Database Systems 1.1.1 Early Database Management Systems 1.1.2 Relational Database Systems 1.1.3 Smaller and ... 2.3.1 Relations in SQL

Global site tag (gtag.js) - Google Analytics