| |

VerySource

 Forgot password?
 Register
Search
View: 5|Reply: 4

The problem of using TOP in the Select statement

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-3-23 11:30:01
| Show all posts |Read mode
I use vb.net to write asp.net programs, using:
Select top 8 id, idmain, infoCategory, infobt, btColor, fbtime from info Where idmain = 1 order by fbTime desc
This statement, of which top 8 does not work,
The records are all displayed,
Master pointing,
Wait online.
Reply

Use magic Report

0

Threads

303

Posts

109

Credits

Newbie

Rank: 1

Credits
109

 China

Post time: 2020-7-2 18:00:01
| Show all posts
Is it an access database?

If yes, it is because fbTime has duplicate records.
Reply

Use magic Report

0

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 Germany

Post time: 2020-7-2 22:15:01
| Show all posts
You run this sql in the database environment to see if there will be problems!
If there is no problem, it is that there is a problem with the sql statement, you can step through and debug it.
Reply

Use magic Report

0

Threads

3

Posts

4

Credits

Newbie

Rank: 1

Credits
4

 China

Post time: 2020-7-2 23:00:01
| Show all posts
Do all fbTime fields have the same content?
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-7-3 14:15:01
| Show all posts
Access library
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list