query top10 value

[lsy]

can i query the top 10 value in database using sql statement??
i had a series of data... which i just want the top 10 largest value to be display...
pls advice...

[erickwidya]

something like

SELECT TOP 10 field_name FROM table_name ORDER BY field_largest DESC

plz give more detail like table name, table value if it's not working

[lsy]

something like

SELECT TOP 10 field_name FROM table_name ORDER BY field_largest DESC

plz give more detail like table name, table value if it's not working

this will return the top 10 record not the value of a column...
eg:
counterA
6
11
5
3
12
7
10
2
8
9

i want it return as
counterA
12
11
10
9
8
7
6
5
4
3

you get what i means?

[gilly914]

I would query it like this :

SELECT field_name FROM tabl_name ORDER BY field_largest DESC LIMIT 10

Thats how I do it, and it ususally works...

[lsy]

I would query it like this :

SELECT field_name FROM tabl_name ORDER BY field_largest DESC LIMIT 10

Thats how I do it, and it ususally works...

It does not work... i'm using MS Access to make this query... it does not recognise the LIMIT 10... pls advice...

[NigelQ]

this will return the top 10 record not the value of a column...
eg:
counterA
6
11
5
3
12
7
10
2
8
9

i want it return as
counterA
12
11
10
9
8
7
6
5
4
3

you get what i means?

I do not beleive this to be correct.

The order by will be called before the top 10 is selected, which should give you what you desire. This will work in Access.

So, as Erick suggested, I think this is what you need:

SELECT TOP 10 field_name FROM table_name ORDER BY field_largest DESC

Hope this helps,

- Nigel

[erickwidya]

try this one

SELECT TOP 10 CounterA from table_name ORDER BY CounterA DESC

[Madhi]

>>SELECT field_name FROM tabl_name ORDER BY field_largest DESC LIMIT 10

That is for MySQL

>>this will return the top 10 record not the value of a column...

Did you try the Query suggested by erickWidya
Thats the answer
It seems you didnt try that
What do you mean by "this will return the top 10 record not the value of a column..."?

[lsy]

Thanks all.... i been success to query about... but right now i have some concern if i have a largest value data which have more than 10 times how can i control which only display 10 record??
eg:
counter a:
12
12
12
12
12
12
12
12
12
12
12
12
12

[Madhi]

Select Distinct Top 10 CounterA from yourTable ORDER BY CounterA DESC

[lsy]

Thanksss all...