Darcy Frady
  • Female
  • United States
Share

Darcy Frady's Discussions

Solution Compatible Oracle and MySQL for LIMIT clause

Started this discussion. Last reply by Mike Trout Aug 22, 2013. 3 Replies

Is there a solution that is compatible Oracle and MySql to limit the number of rows returned by a query ?For example in mysql there is the LIMT clauseSELECT * FROM myTable LIMT 10;In Oracle we use a…Continue

Gifts Received

Gift

Darcy Frady has not received any gifts yet

Give a Gift

 

Darcy Frady's Page

Latest Activity

Darcy Frady liked Peirre Calzadilla's group Oracle Senior DBA Group
Dec 16, 2013
Darcy Frady joined Peirre Calzadilla's group
Thumbnail

Oracle Senior DBA Group

Learn database technology with Oracle Senior DBA Group. The group will feature latest updates, knowledge blogs, events and job postings. Contribute your oracle experienceSee More
Dec 16, 2013
Darcy Frady liked Shelby Max's group Oracle Recruitment Group
Oct 22, 2013
Darcy Frady joined Shelby Max's group
Thumbnail

Oracle Recruitment Group

Get a chance to get selected and promoted for Oracle jobs through Oracle Recruitment Group. The group will feature jobs and recruiters available online for best job sharingSee More
Oct 22, 2013
Darcy Frady liked Kattey Henry's group Oracle Community
Oct 14, 2013
Darcy Frady joined Kattey Henry's group
Thumbnail

Oracle Community

Oracle Community group will allow you to interact, exchange and share knowledge with Oracle people and exchange tips and useful job postings in return – all about OracleSee More
Oct 14, 2013
Darcy Frady liked Arden Such's video
Oct 8, 2013
Darcy Frady liked Yasmine Kay's video
Oct 8, 2013
Mike Trout replied to Darcy Frady's discussion Solution Compatible Oracle and MySQL for LIMIT clause
"To get the last 5 records SELECT * FROM account HAVING (SELECT MAX(id) FROM account) - 5 < id To get the first 5 records SELECT * FROM account HAVING (SELECT MIN(id) FROM account) + 5 > id"
Aug 22, 2013
Elizabeth Warren replied to Darcy Frady's discussion Solution Compatible Oracle and MySQL for LIMIT clause
"in oracle it's select * from mytable where rownum < 11 the alternative is an analytic function but mysql does not support that."
Aug 22, 2013
Barn Mitchel replied to Darcy Frady's discussion Solution Compatible Oracle and MySQL for LIMIT clause
"If your table has a unique id column (or combination of columns), you can do the following: select t.* from t where (select count(*) from t t2 where t2.id <= t.id) <= 10; The correlated subquery in the where clause is standard SQL…"
Aug 22, 2013
Darcy Frady liked Henry Cooper's group Oracle Consultants
Aug 22, 2013
Darcy Frady joined Henry Cooper's group
Thumbnail

Oracle Consultants

Promote your Oracle talent and knowledge and share it with Oracle Consultants group. Grow, learn and interact with Oracle people to network with Oracle communitySee More
Aug 22, 2013
Darcy Frady posted a discussion

Solution Compatible Oracle and MySQL for LIMIT clause

Is there a solution that is compatible Oracle and MySql to limit the number of rows returned by a query ?For example in mysql there is the LIMT clauseSELECT * FROM myTable LIMT 10;In Oracle we use a condition on the rownum columnI want some code that works for both MySQL and OracleSee More
Aug 22, 2013
Darcy Frady is now a member of OracleConnections
May 29, 2013

Comment Wall

  • No comments yet!

You need to be a member of OracleConnections to add comments!

Join OracleConnections

 
 
 

© 2019   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service