Learn database in a simple and easy way.
Hi Vivek, Is there any possible, To get the single row without using where clause?
Hi Vairavan, You can use the Top clause to get the single row without using where clause.Is that the solution of your query or am I misunderstood your question.BR\
This comment has been removed by the author.
select top 1 * from FeeReciept_Main order by FeeRecieptNo desc
hi vivek,i am learning manual testing.is sql,mysql,oracle 10g same..i mean same queries everywhwre
Hi , Thanks for your invaluable comments:-)
set rowcount 1select * from RQS_INVENTORY order by anycolumnname
Hi Vivek,
ReplyDeleteIs there any possible, To get the single row without using where clause?
Hi Vairavan,
DeleteYou can use the Top clause to get the single row without using where clause.
Is that the solution of your query or am I misunderstood your question.
BR\
This comment has been removed by the author.
Deleteselect top 1 * from FeeReciept_Main order by FeeRecieptNo desc
Deletehi vivek,
ReplyDeletei am learning manual testing.is sql,mysql,oracle 10g same..i mean same queries everywhwre
Hi ,
DeleteThanks for your invaluable comments:-)
set rowcount 1
ReplyDeleteselect * from RQS_INVENTORY order by anycolumnname