Interview Questions

7 comments:

  1. Hi Vivek,
    Is there any possible, To get the single row without using where clause?

    ReplyDelete
    Replies
    1. 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\

      Delete
    2. This comment has been removed by the author.

      Delete
    3. select top 1 * from FeeReciept_Main order by FeeRecieptNo desc

      Delete
  2. hi vivek,
    i am learning manual testing.is sql,mysql,oracle 10g same..i mean same queries everywhwre

    ReplyDelete
    Replies
    1. Hi ,
      Thanks for your invaluable comments:-)

      Delete
  3. set rowcount 1
    select * from RQS_INVENTORY order by anycolumnname

    ReplyDelete