Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

fetch data from table

3 Posts 3 Posters 0 Views 1 Watching

S Offline
S Offline
senthilmca

wrote on last edited by

#1

hi, i am using MSSQL as my backend, i want to fetch top 3 students from the Student table.Plz help me Senthil
_ A 2 Replies Last reply

0
S senthilmca

hi, i am using MSSQL as my backend, i want to fetch top 3 students from the Student table.Plz help me Senthil
_ Offline
_ Offline
_AK_

wrote on last edited by

#2

This was already answered yesterday in other forum have you checked that?

Best Regards, Apurva Kaushal
1 Reply Last reply

0
S senthilmca

hi, i am using MSSQL as my backend, i want to fetch top 3 students from the Student table.Plz help me Senthil
A Offline
A Offline
Amit Kumar G

wrote on last edited by

#3

use top operator. SELECT TOP 3 from table [order by field]. Please note order by clause is optional and if require use it. Amit
1 Reply Last reply

0

Log in to reply