HOW TO SELECT 50% LAST ROW FRO DATABASE TABLE

Hi,

you can try this

SELECT     TOP   (SELECT     COUNT(*) / 2 AS Expr1
  FROM          QuestionTab) qid, qname, opt1, opt2, opt3, opt4, ans
FROM         QuestionTab AS QuestionTab_1
order by qid desc

But here it selects top half record

you can get last half by order by id

I hope you got What I said

All the Best

Use the limit clause:

SELECT * FROM tablename LIMIT 50, 50

i.e. select 50 records, starting at the 50th record.

This will work for MySQL but we need to know what your DBMS platform is as each platform works differently (e.g. MSSQL doesn't have LIMIT!)

For MSSQL try:

SELECT TOP 50 PERCENT * from tablename ORDER BY id desc

This works if 'id' is a primary key field which auto increments.

Select TOP 50 PERCENT  * from table_name ORDER BY COLUMN_NAME DESC

to get last 50%

Hello all,
Select top 50 will give only top 50 or last if order by DESC
but

Select Top 50 Percent * from table_name order by id DESC

will give last 50%

U can set the percentage in a variable and use like

Declare @Percentage float
set @percentage = 50
Select Top (@percentage) Percent * from table_name order by id DESC