Does ‘Select’ always order by primary key?

by

No, if you do not use “order by” you are not guaranteed any ordering whatsoever. In fact, you are not guaranteed that the ordering from one query to the next will be the same. Remember that SQL is dealing with data in a set based fashion. Now, one database implementation or another may happen to provide orderings in a certain way but you should never rely on that.

More Related Contents:

  1. How do I reset a sequence in Oracle?
  2. ORA-00904: invalid identifier
  3. Strings as Primary Keys in SQL Database [closed]
  4. How can I get column names from a table in Oracle?
  5. Is there any boolean type in Oracle databases?
  6. SQL ROWNUM how to return rows between a specific range
  7. MySQL equivalent of DECODE function in Oracle
  8. SQL recursive query on self referencing table (Oracle)
  9. create table with sequence.nextval in oracle [duplicate]
  10. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  11. Deferrable Constraints in SQL Server
  12. Oracle (Old?) Joins – A tool/script for conversion?
  13. How to populate calendar table in Oracle?
  14. What is it exactly a BLOB in a DBMS context
  15. What can cause an Oracle ROWID to change?
  16. Is there a version control system for database structure changes?
  17. adding primary key to sql view
  18. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  19. How do I list all the columns in a table?
  20. How do you interpret a query’s explain plan?
  21. Oracle DB: How can I write query ignoring case?
  22. How do NULL values affect performance in a database search?
  23. Query a Table’s Foreign Key relationships
  24. Retrieve Oracle last inserted IDENTITY
  25. Oracle , != , ^= operators
  26. SQL Server equivalent of WM_CONCAT function [duplicate]
  27. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?
  28. Oracle SQL: Update a table with data from another table
  29. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  30. How to show all privileges from a user in oracle?

Leave a Comment