SQL Query

[MindHunter]

umeed ha tamam readers tandrust hongay. dear experts mjy sql data tables k hawalay sa ek problem ha.
suppose ma na ek table ma kuch record enter kya hai. ma chahta hun k os table ma jo sab sa last record ha oska koi ek cell ki value daikhai ha to es k lya kya query hogi........
i am waiting.... pleaase reply soon.

[muhammadali]

Salam , bro apki post ko dheka , query bht simple hy

select column name from table name order by column name desc

ye query sary records dhikaye gi last sy
or agr apko just last record view krna hy specific column ka to usky liay ye query hy

select top 1 column name from table name order by column name desc

hope it will help, Take care

[MindHunter]

you mean
SELECT TOP 1 column FROM table ORDER BY DESC

ma na ek aur query daikhi hai.
SELECT LAST(column) FROM table

[MindHunter]

by the way....... very much thanx for reply............... ap wali query ma na abi conform ki ha