Department_id ,emp_count, dept_percentage
In a table the persons name is in lower case "abc" and is there any SQL query to obtain that persons name as "abc" as an output?
I have table with one column. Type varchar.. phone --------------- 99samn44423m44 8034skdf3453a2 909090abc4567d i want to get numeric values.. I mean my output will be phone --------------- 994442344 80343453a2 9090904567 thanks in advance.. sateesh
How to retrieve a second highest salary from a table? note:suppose salaries are in duplicate values eg: name sal malli 60000 pandi 60000 rudra 45000 ravi 45000
I have following table as books101 book_no book_name author_name cost category1234 c dennis 450 system1235 Oracle loni 550 database1236 sql loni 250 database1237 PL/SQL scott 750 database now I want to list all the authors and book name that has more then 1 book written by them.Pls help