Answer Posted / priya
select * from emp where empno < (select max(empno) from
emp) and rownum<2 order by empno desc
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can we write dml inside a function in sql server?
What are the two virtual tables available at the time of database trigger execution?
what is a constraint? : Sql dba
Does view store data in sql?
How to make a copy values from one column to another in sql?
What is the difference between clustered and non-clustered index in sql?
How can you create an empty table from an existing table?
What are functions in sql?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
How can we implement rollback or commit statement in a trigger?
What is sql*loader and what is it used for?
What is function and procedure?
What are the different types of dbmss?
Can you have more than one key in a database?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this