What is left join example?
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle pl sql developer?
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)
What is sql clause?
What is pl sql in oracle?
How does a covering index work?
How do I partition a table in sql?
Why coalesce is used in sql?
How many clustered indexes can be created on a table?
List different type of expressions with the example.
What is a cursor for loop ?
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
Which function is used to return remainder in a division operator in sql?