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
- 9119 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 is sql comments?
How do I make my sql query run faster?
What is rtm stands for?
What is rownum and rowid?
What is a boolean in sql?
Can we group by two columns in sql?
What is the most important ddl statements in sql are?
Is join and inner join the same?
What is compound trigger?
How do I write a sql query in pgadmin 4?
What are the built in functions of sql?
What are the rules to be applied to nulls whilst doing comparisons?
Is grant a ddl statement?
What are dml commands?
Is oracle sql free?
