i want to show top 3 record from table,pls help me

Posted by Umeshdwivedi under ASP.NET on 6/25/2011 | Points: 10 | Views : 1934 | Status : [Member] | Replies : 18
dear all
i want to show top 3 record
1-i have a table where 2 field ID and cat_type
i want to show top 3 record from cat_type column
how can i do pls help me

Latest Technology Trainer
And Part time software consultant



Responses

Posted by: V8527336232 on: 6/25/2011 [Member] Starter | Points: 25

Up
0
Down
select top 3 ID , cat_type from cat_type

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Umeshdwivedi on: 6/25/2011 [Member] Starter | Points: 25

Up
0
Down
Dear Sir
this query show all the record
"select top 3 ID , cat_type from catagory " here catagory is table name pls suggest me
so what can i do


Latest Technology Trainer
And Part time software consultant

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vilasgite080 on: 6/26/2011 [Member] Starter | Points: 25

Up
0
Down

SELECT top 3 * FROM table_name
please refer : http://www.w3schools.com/sql/sql_top.asp

If this reply hepls your post.then "MARK AS ANSWER"!



Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vforvijay on: 6/27/2011 [Member] Starter | Points: 25

Up
0
Down
hi..Try this code..
select top 3(cat_type) from catagory


Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Shoyebaziz123 on: 6/27/2011 [Member] Starter | Points: 25

Up
0
Down
hi try this.....select top(3) ID , cat_type from catagory

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rakeshbinu on: 6/27/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

http://www.w3schools.com/sql/sql_top.asp

RR

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 6/27/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi,

Refer this,

http://msdn.microsoft.com/en-us/library/ms189463%28v=sql.90%29.aspx

Regards,
Susan

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakn2 on: 6/27/2011 [Member] Starter | Points: 25

Up
0
Down
select top 3 * from tablename

Thanks&Regards
LakshmiNarayana Nalluri.

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 6/27/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Select top 3 * from cat_type


Thanks
Karthik
www.f5Debug.net

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Umeshdwivedi on: 6/27/2011 [Member] Starter | Points: 25

Up
0
Down
dear every one
any query is not work pls check your self

Latest Technology Trainer
And Part time software consultant

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakn2 on: 6/28/2011 [Member] Starter | Points: 25

Up
0
Down
it should work no need check ,check yourself ok.

Thanks&Regards
LakshmiNarayana Nalluri.

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prabhakar on: 6/28/2011 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hello .. Umeshdwivedi


Say ur Full Requirement then I am try to Solve it . .

Best Regard's
Prabhakar

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vilasgite080 on: 6/28/2011 [Member] Starter | Points: 25

Up
0
Down
hi umesh...
which database server are you used?
---------------------------------------------------


Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vilasgite080 on: 6/28/2011 [Member] Starter | Points: 25

Up
0
Down
hi
http://www.techonthenet.com/oracle/questions/top_records.php
refer this link however your database server......... find here your queries answwer.

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Umeshdwivedi on: 6/28/2011 [Member] Starter | Points: 25

Up
0
Down
ms-access

Latest Technology Trainer
And Part time software consultant

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Umeshdwivedi on: 6/28/2011 [Member] Starter | Points: 25

Up
0
Down
Dear Sir
i m populate datalist with the coding
and i want to show top 3 record from specific column,
my database on ms-access where a table,table name catagory and catagory table have two column
ID and cat_taype i want to show top 3 record from cat_type column


Latest Technology Trainer
And Part time software consultant

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vilasgite080 on: 6/28/2011 [Member] Starter | Points: 25

Up
0
Down
ok umesh
just try this..
http://www.techonthenet.com/access/queries/top_results.php
------------------------
"MARK AS ANSWER" IF ITS HELP YOUR POST

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/8/2012 [Member] Bronze | Points: 25

Up
0
Down
select top 3 cat_typefrom student

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response