sql server 2016 basic select issue
I have basic database table with some rows. see the queries below. first query selects a record from the database.. you see the result. that result is not the same as the other two result. yet I am retrieving the same record from the table using the different columns/methods. correct record is the second and 3rd select queries.
PWTransferID is the primary key. PWtransfernumber is non clustered index/Unique
I am really confused and have never seen a problem like this. can anybody shed some light on this for me. almost like the database is broken some where.
Solution
Is that just a typo in the first query? Should 227 be 277?
- query multiple IIF statement
- count distinct values while left joining
- MySQL: Order by Count(*)?
- How to select data items of a certain length?
- Comparing JSON-typed column with specific string value
- How to treat MAX() of an empty table as 0 instead of NULL
- Declare variable in SQLite and use it
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- Snowflake: Using multiple AND/OR statements breaks my date filter
- How to get the insert ID in JDBC?
- Add a column to a DB2/400 table with a specific ordinal position
- SQL conditional MAX extraction
- Drop Column from Large Table
- Can using isnull in a where statement cause problems with using indexes?
- How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?
- SQL Concat Subquery
- Oracle client appears to be transmitting all 4000 varchar characters for each row
- Java JDBC executeUpdate not working on Delete SQL with TRUNC function in where clause
- Oracle thinks table doesn't exist during alter
- How to bulk update sequence ID postgreSQL for all tables
- Remote clickhouse error: DB::Exception: There's no column '__table1.event_params.key' in table '__table1'
- How do I catch a query exception in laravel to see if it fails?
- How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
- SQL Stored Procedures not finishing when called from Python
- Make a paginated table without offset limit
- How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
- How do composite indexes work?
- Rank rows by specified partition
- SQL Get "ISO Year" for ISO Week
- How to insert an array value to an existing JSON document?