For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi all
i have a table called test
test_id test_salary
1 1000
2 1000.78
3 2000
4 3000
5 2000.87
like this i have 1000 records , i need only the test_salris who are having decimals like 1000.78,2000.87
how can i write the query pls advice