Follow this topic

Posted on:

04 Nov 2021

2

[solved]Regarding > operator Output in Video

in SQL / Other Comparison Operators

code was in video
WHERE hire_date > '2000-01-01';
Why > operator retrieve date only from one month Jan why not another month and year because they are greater than 2000?

explaination-
i think i got the answer the reason due to hire_date limited to first month of 2000

0 answers ( 0 marked as helpful)

Submit an answer

related questions

0

8

Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each

Yuvraj Shivaji Dhepe

0

8

DOUBT REGARDING SQL- COUNT QUERY

Yuvraj Shivaji Dhepe

0

6

Query Regarding Having assignment in SQL.

1

6

The output shows zero rows returned when you Rollback?

6

6

Can we include answer output for guidance?

Meenakshi Akila P.S

0

6

Regarding assignment on UNION:

Tanmay Chakraborty

0

6

I HAD GIVEN OUTPUT AS SALARY_P BUT WHEN I CALLED THE PROCEDURE IT ALSO ASKING FOR IN OF THE OUT

0

6

I wrote this below code , but the output contained both M and F. I did not got the logic

Meenakshi Akila P.S

0

4

regarding min() function for department no

0

4

Resolved: Confusion regarding Question 4.

1

4

Resolved: Output parameters

0

4

Resolved: Question regarding the SQL SELF JOIN lecture