Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table .in the table 100 recored is there .we have
get the single row with out using clause..
- 3 Answers
- 9417 Views
- I also Faced
- E-Mail Answers
Answer Posted / nannesaheb chinthalacheruvu
Question is not clear..kindly elaborate the same.
As i understand is "Retrive the single row with out using the where clause"...if so the below query may help you to achive the same.
Select e.*,max(rowid) from emp e;
select e.*,min(rowid) from emp e;
| Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
What are sql indexes?
what are the advantages of mysql in comparison to oracle? : Sql dba
Is there any restriction on the use of union in embedded sql?
What is the difference between local and global temporary table?
Explain the commit statement.
Explain the difference between rename and alias?
Can we use having without group by in sql?
What do you mean by stored procedures?
what does myisamchk do? : Sql dba
What are tables in sql?
Which is better trigger or stored procedure?
What is sql character function?
What does where 1 1 mean in sql?
What is cursor in pl sql?
Advantages and disadvantages of stored procedure?
