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 : 3124 | Status : [Member] | Replies : 18

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

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

0	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

0	select top 3 cat_typefrom student Umeshdwivedi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts