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
- 9055 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
How is indexing done in search engines?
Can a foreign key be null?
What is orm in sql?
who introduced sql?
Is record in pl sql?
Why do we use triggers?
How do you write an inner join query?
What are all different types of collation sensitivity?
What does varchar include?
What is the size of partition table?
What are the types of variable use in pl sql?
what are the security recommendations while using mysql? : Sql dba
What is sqlerrd?
How do I truncate a sql log file?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
