Answer Posted / prakash kumar
select max(rownum)from table_name;
this will also give number of rows in your table
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is raid? How does it help storage of databases?
How to look at the current sql*plus system settings?
What are the triggers associated with image items?
How does a covering index work?
what are the drivers in mysql? : Sql dba
what are myisam tables? : Sql dba
What is a null value?
Which one is better sql or oracle?
What are the syntax and use of the coalesce function?
What is a heap in sql?
what is a primary key? : Sql dba
How to run sql*plus commands in sql developer?
What is the difference between cluster and non-cluster index?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What are the 3 modes of parameter?
