How to limit my database table row? the row i want to make is until 5 rows only

Question

Hi everyone i want help for my project i want to limit my database table row until 5 rows only using csharp code please help me for my project...thanks everyone.

Vulpes · Answer

If you mean that you only want a query to return a maximum of 5 rows then you can use the 'SELECT TOP 5 * FROM table' syntax.

Black Diamond · Answer

hi! suthish nair thank you form the response...

Black Diamond · Answer

Hi! vulpes Thank you for the response ... your code works!...

Suthish Nair · Answer

Just check for row counts. select COUNT(1) from table1.